searching multiple tables
Posted: Mon Dec 05, 2005 4:42 pm
is it possible to search multiple tables when using php to search the database? any links or code would be greatly appreciated
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$someID = 1;
SELECT table1.*,table2.* from table1
where
table1.id = $someID and table2.id = $someID