How to build a search form
I've got a basic search form working when a user enters either an appropriate uniqueID for a record, or for a different identifying column. The problem I'm having is that the client ALSO wants to add to this form two date fields, so a user could also search between two dates, along with the other values, or by the date range alone. How can I modify this select statement to try and get it to work?
$Results->setQuery("SELECT * FROM Reservations WHERE (RID LIKE ? OR Type LIKE ?) ORDER BY RID");