PHP/MySQL multiple textbox's search one record
Posted on 2006-05-29
Ive got a php/mysql app that im tryin to search results on one record from up to 5 textboxes.
The results processor php page has this:
$query = ("SELECT * FROM tableA
WHERE contid LIKE '$contid%'
AND city LIKE '$city%'");
The PHP search form ive got 5 textboxes that i would like to be able to punch in up to 5
The actual record name in the table is contid.
Textbox1 name is contid
Textbox2 name is contid2
Textbox3 name is contid3 and so on up to 5
Can i put an AND/OR statement in the processor page to query also the contid2 and so on?
Any help would be appreciated, thanks