[PHP] Help with a search array.

[Philip J. Newman]

heres my example:

I want to break up the search words in a string.

eg: $q = green eggs 

would like that to be

$q1 = green
$q2 = eggs

... then ....

the mysql process

  $sql = "";

      for ($i = 0; $i < $num; $i++)
    if (strlen($getme_arr[$i]) > 0)
      $sql .= " '%".$getme_arr[$i]."%'";

  $sql .= " ORDER BY `id` ASC LIMIT 0, 30";

... This should send to my sql ...

SELECT * FROM `hyperlinks` WHERE 1 AND `keywords` LIKE "green" AND `keywords` LIKE 
"eggs" ORDER BY `id` ASC LIMIT 0, 30

How ever it really down't want to work.  Any Suggestions

Philip J. Newman
PhilipNZ :: Design Solutions
http://www.philipnz.com/
[EMAIL PROTECTED]
ICQ# 20482482
+64 25 6144012