Search Query

["Ng Hwee Hwee" <hhwee@xxxxxxxxxxx>]

Dear all,

i need help with my search query statement.. what is wrong with my code?

<snip>
      $word = split(" ", $keyword);
      $num_words = count($word);
      $word_str = "";
      $criteria = "";

      for ($i=0; $i<$num_words; $i++)
      {
          if ($i)
             $word_str .= "and colName like '%".$word[$i]."%' ";
          else
             $word_str .= "colName like '%".$word[$i]."%' ";
      }

      $word_str .= "and col2 = '$foo' ";

      $criteria .= "$word_str ";
      $table .= "db_table";

      $query = "select * from ".$table." where ".$criteria;
</snip>

when i try to echo $query, i get ---  select * from where

and so of course MySQL gives me an error 1064 near ' where '

what happened?

thanx thanx!

hwee