logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 05-14-2012, 11:19 AM   #1
scotty_85
 
Join Date: May 2012
Posts: 1
Default Advanced recordset help!

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
scotty_85 is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:21 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com