select help needed

[pelegk2]

i have a table with user name,user password,full name
and another table with buy_id,user name
know when i print to the screen the row with the buy_id
i donnt want to print the user name but his full name (which is on the other table!
how do i do that?
thanks in advance
peleg

[zhabala]

SELECT * FROM users, orders WHERE users.user_name = orders.user_name AND buy_id = $buy_id

Then you will get all fields from table users and all fields from table orders. So you can print them as you want

Zdenek

[pelegk2]

🙂