Re: Multiple Select

Not to be condesending, but this is a simple and basic function of any SQL syntax. Make the effort to actually try to learn it yourself. This is clearly documented in the MySQL docs, as well as hundreds of tutorials that get you started with mysql. I'll let ya off the hook this time. select * from table1, table2, table3, table4, table5 where name='$keyword'; if you're trying to do a keyword search it needs to be like this: select * from table1, table2, table3, table4, table5 where name like %'$keyword'%; ----- Original Message ----- From: Dhaval Desai <dhaval_adams@yahoo.com> To: <php-general@lists.php.net> Sent: Saturday, December 23, 2000 12:19 AM Subject: [PHP] Multiple Select > Hi! > > > I want a little help from you guys. I want a multiple > select statement whoch can search for the same keyword > in various tables in the same database.. > THis will be for a complete site search. > > > Seomthing like. > "select * from table where name='$keyword'"; > > Something like that but should search all the > tables...in the databse. > > > > Is it possible to do that way..? I think the key > option...or something in Mysql..will do that..Please > tell me how to do that.. > > > Thank You > Dhaval Desai > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >