On Sat, Nov 13, 2004 at 12:30:43PM -0800, Stuart Felenstein wrote: > $sql = "SELECT PostStart, JobTitle, Industry, > LocationState, VendorID > FROM VendorJobs"; > echo $sql; > //if ($Ind) > $sql .= "WHERE VendorJobs.Industry = $s_Ind"; > > As you can see above s_ind is an array , comma > delimited. To me this all looks fine. to the parser, > well ;)
You can't compare a column with a comma-delimited list of numbers like that, and you also want to make sure there is a space before the 'WHERE' keyword. You want: $sql .= " WHERE VendorJobs.Industry IN ($s_Ind)"; -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
