|05-14-2012, 10:19 AM||#1|
Join Date: May 2012
Advanced recordset help!
I'm trying (and have been for many hours) to build a search and results page with the advanced recordset function.
I trialed it first with this and it works fine;
WERE ff_id = varff_id
OR technical_name LIKE vartechnical_name
I then tried adding this
AND current_location LIKE varcurrent_location
when I add another variable (and only enter values in the name and location form fields) the results table shows 0 records (of which there are lots).
search page form field id's are the same as in the tables. everything is a "text" value, default % and run time value $_GET['field_name']
Thanks for your advice and please bare with me, i'm a novice