RE: Re: Help: Database Search

[Stuart Felenstein <stuart4m@xxxxxxxxx>]

I think I'm almost there :)
Only right now I'm getting an error message:

"Query failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server
version for the right syntax to use near '' at line 3"

<?php
$where = array();
$Ind = "";
$Ind = $_POST['Ind'];
  if (count($Ind) > 1)
  {
    $IndStr = implode("','", $Ind);
    $where[] = "VendorJobs.Industry IN($IndStr)";
  }else{
    $where[] = "VendorJobs.Industry = {$Ind[0]}";
}
?>
<?php
$sql = 'SELECT PostStart, JobTitle, Industry,
LocationState, VendorID
        FROM VendorJobs
        WHERE ' . implode( ' AND ', $where );

$result = mysql_query($sql) or die ("Query failed: "
.mysql_error());
while($row = mysql_fetch_assoc($result))

I can't find the problem.
Anyone see anything ?

Thank you.
Stuart

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php