I am using PHP Runner 5.2 and cannot seem to discover how to validate a search routine of two fields in a MySql database where I want to require one of the fields not be blank.
In other words, searching two fields, FirstName and LastName, allow a search that may or may not have a value input for FirstName but require input for LastName in order for the search to execute.
How can I set a maximum number of "hits" to return?
Right now, I have a search page up that if both fields are left blank returns, the search runs and returns all records in a MySQL database.
I could not find answers to these questions searching the Help file.
Thank you.