Get rid of percentage signs in your keyword... See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan -----Original Message----- From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: please help: search database - code attached Hi, I have a table of jobs. I would like user to search the jobs on three columns: description, location, type, on the search page, i have one text field, and one drop down menu. the search field will be used for keywords against the description and location columns. the drop down will choose between the ONLY two types of entry for a type column (permanent and temp) here is my sql (i'm using mysql fulltext search) Select * from tbl_jobs WHERE MATCH (description, location) AGAINST ('%mm_keywords%') AND type = 'mm_type' i keep on getting empty sets. is there anything i am missing here? any help would be greatly appreciated. cheers Shez __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
