issue pulling database info from a different table

[abda53]

im having a problem trying to pull some data from the database

$result = mysql_query("SELECT * FROM ims_image ORDER BY i_id desc limit 10");
$count = 0;
while($image_info = mysql_fetch_assoc($result)) {
$count = $count + 1;
$filesize = round($image_info[size]/1024);
$imageurl = "/$image_info[u_id]/$user_info[code]/$image_info[i_id].$image_info[ext]";
$thumburl = "/thumbs.php?u=$image_info[u_id]$user_info[code]&i=$image_info[i_id]";

how can i pull $user_info

?

[nemonoman]

SELECT code FROM userinfo WHERE something=something?

[abda53]

"SELECT * FROM ims_image 

is there.. but i also need to select from 'ims' as well

[abda53]

should i want to join the tables? im not sure how to do that.

[abda53]

nevermind i had to join the tables. i figured it out though

SELECT ims.u_id, ims.code, ims.fname, ims.lname, ims_image.title, ims_image.views, ims_image.size, ims_image.i_id, ims_image.ext FROM ims JOIN ims_image ON ims_image.u_id = ims.u_id ORDER BY ims_image.i_id DESC LIMIT 10