如何在MySQL中包含PHP数组变量

Question

I am trying the following:

mysql_query("SELECT `lastUpdate` FROM `summoner` WHERE `name` = '$summoner['name']';");

But it doesn't work. I think its because of the ' in $summoner['name'].

Any way to workaround without:

$summonerName = $summoner['name'];

?

Answer 1

You can use (no single quotes on the occurance)

"SELECT `lastUpdate` FROM `summoner` WHERE `name` = '$summoner[name]'";

Or wrap the Whole array with quotes in curly brackets

"SELECT `lastUpdate` FROM `summoner` WHERE `name` = '{$summoner['name']}'";