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
