php MySQL查询中的关联数组

Question

I have a mysql query in php:

mysqli_query($link,"SELECT * FROM `content` WHERE `page`='$cont_sel_e['name']'")

However it does not return anything. I know that the error are the single quotes in the '$cont_sel_e['name']' part. The question is, how do I format it correctly, so that it works?

Answer 1

You do not actually need all those quotes.

mysqli_query($link, "select * from content where page = '{$cont_sel_e['name']}'");

That will work just fine