<? how to row same fileds names in join?

[bn1995]

we have 2 tables 1 for usernames and it has ID for each username nad other table is mailbox ,,, mails by ID now i wanna do join between these 2 tables and i want to get id for username and id for mail box from same query ?

$res= "SELECT users.id,users.username,mailbox.id, mailbox.sender,mailbox.subj,mailbox.date... ".
"FROM users, mailbox ".
"WHERE mailbox.receiver='".$_SESSION["myusernam... AND mailbox.sender=users.username";

thanks in advance.

[Weedpacket]

You already are.
"SELECT users.id, users.username, mailbox.id...."
If you want you can add aliases to rename them
"SELECT users.id as user_id, users.username, mailbox.id as mailbox_id...."

[bn1995]

Weedpacket Thank you alot

its working fine .


thank you again