have a form with something like
<input type="text" name="TechContact" value="">
then submit it to a page that might do something like
$Query = "SELECT * FROM enet WHERE TechContact LIKE '%$TechContact%' AND
AdminContact LIKE '%'";
which will locate anything CONTAINING what the user enters in the text field
HTH
Beau
// -----Original Message-----
// From: Devon [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 6 September 2001 10:08 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Newbie Help: Searching
//
//
// $Query = "SELECT * FROM enet WHERE TechContact LIKE '%' AND
// AdminContact
// LIKE '%'";
//
// This query simply prints out my entire tables, is there a
// way using PHP so I
// can make the '%' a user input so they can search the table
// under those
// fields.
//
// Cheers
//
//
//
// --
// 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]
//
--
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]