On Saturday 19 January 2002 13:11, Chris Payne wrote:
> Hi there,
>
> I know this is probably a REALLY simple problem, but I can't get this to
> work. I need to get it to cycle through each word and do a search, I used
> this as sent from Beau Lebens (Thank you) but I can't get it to work. It
> works on 1 word querie but if I enter more than 1 it says can't execute
> query, please help and tell me what i'm doing wrong :-)
Anytime you're putting a query to a db and you're not getting the results
expected you should echo the query to see what you're actually sending to the
db. You could also copy and paste the query into the mysql-client to see what
pops out.
> $words = explode(" ", $test);
>
> // create connection
> $connection = mysql_connect("Localhost","!!!","!!!") or die("Couldn't make
> a connection.");
>
> // select database
> $db = mysql_select_db("tas", $connection)
> or die("Couldn't select database.");
>
> $sql = "SELECT distinct description, email, url, country, category, type,
> rating from search6 WHERE "; foreach ($words as $word) {
> $sql .= "description LIKE '%word%'";
You should probably be using:
$sql .= " description LIKE '%word%' OR "; # note the spaces
> }
After the foreach loop you need to remove the trailing "OR ". That is you
need to remove the last 3 characters from $sql.
> $sql .= "AND category = '$category' AND country = '$country' AND type =
> '$type' ORDER BY description";
This would be a good place to:
echo("The query is $sql<br>");
> $sql = mysql_query($sql,$connection)
> or die("Couldn't execute query.");
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
"Why must you tell me all your secrets when it's hard enough to love
you knowing nothing?"
-- Lloyd Cole and the Commotions
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
