Quick question,
Ive used this syntax before.......
("number" is a MYSQL Field)
number=11 (already in DB)
($number_string is a page variable)
$number_string="9,10,11,12" ;
Code: Select all
$query = "SELECT * FROM table WHERE number IN ('$number_string')";
$result = mysql_query($query);
$number_exists =mysql_num_rows($result);that works fine........But I cant seem to reverse it...
("numbers_field" is a MYSQL Field)
numbers_field=9,10,11,12 (already in DB)
($number is a page variable)
$number_var="11";
Code: Select all
$query = "SELECT * FROM table WHERE $number_var IN ('numbers_field') ";
$result = mysql_query($query);
$number_exists =mysql_num_rows($result);Cant seem to find the IN clause in the manuel.
Any Advice?
Thanks Virgil