PDA

View Full Version : Advanced recordset help!


scotty_85
05-14-2012, 11:19 AM
Hi there

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;

SELECT *
FROM harnesses
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