Pleae rectify my code

[hassan]

Iam trying to compare a row with array of values in php as follows

$array[0]
$array[1]
.
.
.
.
.
$array[n]

$result=mysql_query("select * from databasetable where row1=any($array)");

the above code is not working. Please any body solve my problem.

[schorhr]

Are you looking for
foreach (array_expression as $value)
foreach (array_expression as $key => $value)
?


$stuff = array("foo", "bar", "123");

//cycle through all array elements
foreach ($stuff as $singleelement)
{

//fetch! Good dog!
$result.=mysql_query("select * from databasetable where row1=$singleelement");

// .= will put everyting in the string $result, while = would just overwrite the last query
}



(or something like that, check the syntax, my php is a little rusty ;-)

the above code is not working. Please any body solve my problem.[/QUOTE]

[Twey]

Gods no, don't do that! That will execute a query for every row in the array -- horribly inefficient.

Rather, try:
function quote_mysql_string($s) {
return '\'' . mysql_real_escape_string($s) . '\'';
}

$result = mysql_query(sprintf('SELECT * FROM databasetable WHERE row1 in (%s)', implode(', ', array_map('quote_mysql_string', $array))));