mysql Query issue

[Mark_Nordstrom]

I have an array from a form submitted and converted the results to

$name=$POST['compare'];
$str = implode('<br>', $POST['compare']);
echo $str;

How would I do a SELECT * FROM table WHERE name= with the array results ?

[Derokorian]

$qry = "SELECT * FROM table WHERE name IN ('". implode("','", $name) ."')";

[Mark_Nordstrom]

Yah I've tried that it doesn't return any results.

$query_test = "SELECT * FROM table WHERE name IN ('". implode("','", $name) ."')";
$test= mysql_query($query_test, $db) or die(mysql_error());
$row_test = mysql_fetch_assoc($test);
$totalRows_test = mysql_num_rows($test);
echo $row_test['name'];

Just a test to see if it even returns 1 result but it doesn't.

[johanafm]

What does the query look like? What does the table contain? Do you get any errors?

[Emma]

snap
Does it work if you run the query directly as an SQL statement? For example SELECT * FROM table WHERE name IN ('Tom','Dick','Harry');
Also are you sure you're not getting back more than one row, you check it but don't echo it.