searching multiple tables
Moderator: General Moderators
- elecktricity
- Forum Contributor
- Posts: 128
- Joined: Sun Sep 25, 2005 8:57 pm
- Location: Trapped in my own little world.
- Contact:
searching multiple tables
is it possible to search multiple tables when using php to search the database? any links or code would be greatly appreciated
Code: Select all
$someID = 1;
SELECT table1.*,table2.* from table1
where
table1.id = $someID and table2.id = $someID
Last edited by hawleyjr on Mon Dec 05, 2005 5:05 pm, edited 1 time in total.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
- elecktricity
- Forum Contributor
- Posts: 128
- Joined: Sun Sep 25, 2005 8:57 pm
- Location: Trapped in my own little world.
- Contact: