Hi Chris,

if you have your keywords already in an array all you have to do is to
create the statement:

foreach($arrayname AS $value)
    $where_stmt .= OR $value;

$stmt = "SELECT ...
    WHERE ".$where_stmt

you might have to include an if stmt in the foreach loop because you are not
allowed to start with an OR.
But you get the idea?

Hope this helps,


Global Travellers Network!

"Chris Barnes" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
000201c21ace$65e66ba0$[EMAIL PROTECTED]">news:000201c21ace$65e66ba0$[EMAIL PROTECTED]...
> Hi people,
> Im quite new to the list.
> I am trying to construct a php script that will take a string submitted
> a web site, break it up into keywords and add to an array, then perform a
> query to a mysql db for each keyword in the array. It will then send the
> result to the browser.
> the script is complete so far as I have added the functions to get the
> string from the web site, explode it and add it to an array, but i'm
> trouble putting together a loop that will do a new query for every keyword
> in the array.
> is anyone able to help me with an example of a loop which could work for
> any help very much apreciated :)
> Chris Barnes

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

Reply via email to