I'm trying to build a search query that will allow users to search (via a
textbox) different tables.
For example, I have a table name contacts with columns ContactID, FirstName,
LastName, and Active. I want to be able to search for John Smith or Smith
where Active=yes (as opposed to Active=no which would indicate the contact
is no longer active). I would then like to have the result(s) to have a link
to their respective ContactID.
I don't think this is that difficult, but I'm having difficulty applying the
SELECT statement with the text box.
Any help would be greatly appreciated.
Steve Fitzgerald
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
