php mysql in 加数组,如何在MySQL查询的'IN'子句中使用PHP的值数组？

//get all id's of ur friend that has installed your application

$friend_pics=$facebook->api( array( 'method' => 'fql.query', 'query' => "SELECT uid FROM user WHERE uid IN(SELECT uid2 from friend WHERE uid1='$user') AND is_app_user = 1" ) ); // this query work fine

//your top10 friends in app

$result="SELECT * FROM fb_user WHERE user_id IN($friend_pics) ORDER BY oldscore DESC LIMIT 0,10";

db_execute($result);

i want to retrive ten top scorer from my database stored in oldscore but in my second query the array name $friend_pics is not working i guess,plz help me thanks

解决方案

There is no native support for that. Even the bound parameter APIs do not allow to use arrays for IN clauses. You have to construct the query with some helper code:

$friend_pics = array_map("mysql_real_escape_string", $friend_pics);

$friend_pics = "'" . implode("', '", $friend_pics) . "'";

"SELECT * WHERE user_id IN ($friend_pics) "

A simpler alternative would be mysqls FIND_IN_SET() however:

$friend_pics = mysql_real_escape_string(implode(",", $friend_pics));

"SELECT * FROM fb_user WHERE find_in_set(user_id,'$friend_pics') "