join table

richard181

why this code doesn't work? the $user_id.. is the same id in both the tables..

<?

$query=mysql_query("SELECT fname,picname FROM tra_users,tra_userpic WHERE user_id=$user_id");

while($user=mysql_fetch_array($query)){

echo $user['name'];

}

?>

etully

I think what you meant to write was:

SELECT tra_users.fname,tra_userpic.picname FROM tra_users,tra_userpic WHERE tra_users.user_id=$user_id and tra_userpic.user_id=$user_id;

And that should work for what you want to do.

FYI, this isn't technically a table join. But that's ok because you don't need a table join for what you're trying to do. You want to select two fields out of two tables and you're doing that. A table join has more to do with the relationships between tables and data in one table being used to match rows in another table.

For example, A true table join is more like this: Imagine you know the customer's FIRST NAME in a variable called $first_name. You use that to find out the customer's ID in one table and then you use that information to find their picture in the other table like this:

SELECT tra_userpic.picname FROM tra_users,tra_userpic WHERE tra_users.fname = '$first_name' and tra_users.user_id = tra_userpic.user_id

richard181

aaah yes yes.. i wast forgeting about that..
thanx man..

richard181

what about for something like this how would i go about it?

<?php
$query=mysql_query("SELECT * FROM tra_photo, tra_albums WHERE tra_photo.album_id=tra_albums.album_id");
while($array=mysql_fetch_array($query)){

echo $array['name']."<BR>".$array['picname'];
}
?>

etully

It looks like you're on your way. I'd suggest a good SQL tutorial at this point. There are tons on the Internet (check Google) and there are tons of good "Intro to SQL" books that are cheap. That's your next step.