[RESOLVED] help joining tables

[jerrylouise]

Hi im looking for a little help joining two tables together

This is my current Query

$sql = mysql_query("SELECT * FROM site_comments WHERE artical_id = $id ORDER BY id");

Currently the site_comments table has: id, artical_id, name, date, subject, comment.

I would like to add the following feilds form my user table: username, avatar, rank.

I have never joined two tables together before so i need a little help.

[cahva]

Add user_id field to site_comments table. This will be the reference to user table.

Then add the user table(lets call it "users"). Fields would be: id,username,avatar,rank (and other if you like).

The join would something like this:

$sql = mysql_query("SELECT c.artical_id, c.name, c.date, c.subject, c.comment, u.username, u.avatar, u.rank FROM site_comments AS c 
LEFT JOIN users AS u ON c.user_id = u.id 
WHERE c.artical_id = $id ORDER BY c.id");

[jerrylouise]

ok thats working great, now if i want to add a if statment to this. I know i already hav e a if statment if to allow user edit but its out of the print if, how would i put this if statement in to get it to display text for the diffrent user levels.

<?php
if ($req_user_info['userlevel'] == 9) { 
    print "Admin"; 
}
Else {
	print "Member";
}
?>

      printf("<tr><td class=\"purple_title\" width=\"20%%\">%s" . "</td><td class=\"purple_subtitle\" width=\"35%%\">Posted On: %s" . "</td><td class=\"purple_subtitle\" width=\"45%%\">Subject: %s" . "</td></tr><tr><td class=\"purple_side\" rowspan=\"2\"><p>%s" . "<br />%s" . "</p></td><td colspan=\"2\">%s" . "</td></tr>" , $row["name"], $row["date"], $row["subject"],$row["avatar"],$row["userlevel"], $row["comment"]);
$comid = $row["id"];
if ($usrname == $row[2] || $session->isAdmin()) { 
    print "<tr><td class=\"purple_side\" colspan=\"2\"><a href=\"javascript:ajaxpage('edit/site_comment_edit.php?id=$comid&usrname=$usrname', 'comadd');\">Edit</a></td></tr>"; 
}
else{
echo '<tr><td></td></tr>';
}