U can use this Query for fetching records
Select * from audio,video,download
where audio.id = video.id and audio.id = download.id and audio.id = session.id
Mein kaha rukta ho aarsh-o-farsh ki awaz se...
Mujhe jana ha bohat oocha haad-e-paarwaz se
--- On Mon, 11/23/09, rahul dongre <mady_dongre@xxxxxxxxxxx> wrote:
From: rahul dongre <mady_dongre@xxxxxxxxxxx>
Subject: problem in mysql
To: php-objects@xxxxxxxxxxxxxxx
Date: Monday, November 23, 2009, 11:21 PM
hello all
i have a problem in mysql . i have three table like audio video and download, all tables have a coloumn name user id.i want to fetch a user whose id is equal to session(user id) from all three tables. how i can do this. i also tried join but not getting aspected result please help me.
Rahul Dongre
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo. com/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
