Forum Moderators: open
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