Need help with MySQL....

I realize this isn't strictly PHP3, but...

I developed a site with a PHP script to search a database for keywords with
a certain field. On my local (Win32) box, it worked just fine, but when I
uploaded it to a Red Hat server, it doesn't work.

To be more specific... The search form allows you to choose to find ANY or
ALL of the terms entered (OR or AND, basically). For an AND search, the
script creates a query along the lines of:

SELECT * FROM artwork WHERE keywords LIKE '%car%' AND keywords LIKE
'%truck%';

I can enter this query in PHPMyAdmin on the Red Hat box, and it returns the
expected results, but when my script runs it, it executes the "die" portion
of "$result = mysql_query($query, $mysql_link) or die(...);"

Any ideas on that?

The other problem is an OR search, for which I have the script generate a
query along the lines of:

SELECT *, IF (Keywords LIKE '%car%',1,0) 'car', IF (Keywords LIKE
'%truck%',1,0) 'truck' FROM artwork HAVING car>0 OR truck>0 ORDER BY car
DESC, truck DESC, ImageID ASC;

which, on my Win32 box, finds all records containing any terms and orders
them by relevance (ie records with multiple search terms are listed higher
than those with only one).

This query doesn't work on the Red Hat box, whether in PHPMyAdmin or in my
script.

Any ideas?

TIA for the help.

Scott Nicholson
[email protected]