What am I doing wrong?

[AV1611]

what am I doing wrong?

 

$LIST[0]=1; /for demonstration purposes

$LIST[1]=7; /for demonstration purposes

 

$result=mysql_query(select * from table where field IN $LIST);

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1

[gevans]

$LIST=1; /for demonstration purposes
$LIST.=7; /for demonstration purposes

$result=mysql_query(select * from table where field IN $LIST);

[premiso]

$LIST is an array. If you want to do an IN on it try this:

 

$list[0] = 1;
$list[1] = 7;
$lists = implode("', '", $list);

$result=mysql_query("select * from table where field IN('" . $lists . "')");

 

Should work.

[AV1611]

haven't done it yet, but I already know implode will fix it thanks... I just forgot how to make it wokr