RE: [PHP-DB] Searching database tables

$searchCategory="Company"; [insert html code for drop down box instead of this line] $searchKey="IBM"; $result = mysql_query("SELECT * from $table WHERE ($searchCategory='$searchKey')"); or something like that anyway.... - seb -----Original Message----- From: Devon [mailto:marty_e@hotmail.com] Sent: 04 September 2001 02:15 To: php-db@lists.php.net Subject: [PHP-DB] Searching database tables I have a database in mysql that only has one table, that table has approx 25 fields ..... I need to be able to search for data under each of these fields. Field examples: Company, TechContact, AdminContact, Mobile etc etc I need I guess a pull down menu that would select a field (c above) then be able to search under each field, as in search for company name, or mobile number etc etc. As of yet I cant get my search working ... does any one have any sample code or any suggestion? Any help would be amazing ..... if you have an answer post on here or write to me at work martin@enet21.com.au -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 23/08/2001