[RESOLVED] SELECT WHERE values in list

[adi]

Hello.

Can anybody tell me what's wrong with this script?

$ids="1,2,3,4";

	$sql=mysql_query("SELECT name FROM table WHERE id IN ('$ids')");
	while ($row=mysql_fetch_array($sql))
	{
    	        $name=''.$row['name'].'';
    	        echo $name;
}

It only echoes the first name, not all 4 .

Thanks.

[laserlight]

You should not have the single quotes, methinks:

$sql = mysql_query("SELECT name FROM table WHERE id IN ($ids)");

[adi]

You are a genius 😃, thank you!

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.