Forum Moderators: open

Message Too Old, No Replies

Help with this query

MATCH AGAINST values from DB

         

smagdy

6:13 pm on Jul 26, 2007 (gmt 0)

10+ Year Member



Hello,

I am using PHP + MySQL 5 and struggling with this query..

I am selecting keywords from table then i want to match against these keywords, so i just dono how to tell MySQL that it is value from DB

its last line where i dono how to write it, now it will search against the word 'fromDB' but i want it to search against the variable fromDB which comes from first line!

SELECT ads.id, save_search.keyword as fromDB
FROM ads, save_search
INNER JOIN new_ad_id_temp ON new_ad_id_temp.id = ads.id
WHERE MATCH (ads.zip, ads.location, ads.title, ads.desc)
AGAINST ('fromDB')

Thanks in advance

smagdy

1:52 pm on Jul 27, 2007 (gmt 0)

10+ Year Member



Anybody please?