Page 1 of 1

Syntax Error

Posted: Mon Jan 16, 2006 3:04 pm
by $var
You have an error in your SQL syntax near ' Meal_CID = 1' at line 1

Code: Select all

$sql2 = "SELECT * FROM meals WHERE Meal_Num = 2 , Meal_CID = ".$memcity;
Can anyone see why I am getting an error from this? Let me know if I need to post more.

Posted: Mon Jan 16, 2006 3:09 pm
by duk
like this ??

Code: Select all

$sql2 = "SELECT * FROM meals WHERE Meal_Num ='2' AND Meal_CID = '$memcity'";