Search Query
| From: | Steve Fitzgerald | Date: | Fri, 27 Jul 2001 14:04:08 +0000 |
| Subject: | Search Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10832@lists.php.net to get a copy of this message | ||
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