Re: Need help with MySQL....

On 18 May, Scott S. Nicholson wrote: > 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. After your database queries in the script, use mysql_error() to see what, if any, error is being returned by the mysql daemon; this may assist your debugging. Cheers -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA