Well, two things are driving me crazy...
How do i re-use a variable from the previous page's form whilst adding another variable to the query from the current page ? ...y'know - refining the search criteria over 2 or 3 pages.
I've been referring to the SQL Manual but can't get the WHERE MATCH query working.
SQL MANUAL VERSION:
SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');
MY SQL VERSION:
SELECT * FROM spa
WHERE spa.State LIKE 'varState%' AND spa.Accomodation = 'varType' AND MATCH (Keywords) AGAINST ('spa')
ORDER BY spa.Spa Name
After MATCH are the field names aren't they, and then in the manual it says AGAINST ('database') so i just put the database name in there... but to my eyes there's no reference to my text-input form field...😕
Please help !!!
thanks,
christL
