Page 1 of 1

mysql/php

Posted: Sat Jan 20, 2007 2:31 am
by garry27
what's wrong with this statement- i'm trying to narrow the search down using the sql filter variable i've created but get an error?:

Code: Select all

$sql = mysql_query("SELECT pubID, pubName, pubPostcode from Pubs 
	                  WHERE pubID IN ($sql_str) ") 
				        or die ('query2 invalid on table_data.php: ' . mysql_error() );
TIA

Posted: Sat Jan 20, 2007 8:09 am
by feyd
posting the error may help us.