MySQL table join help

[theone]

[code]<?
mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);
$sql = "SELECT * FROM news_site LEFT JOIN staff ON news_site.poster = staff.id WHERE news_site.show = '1' ORDER BY news_site.posted desc LIMIT 10";
$results = mysql_query($sql);
$rowcount = mysql_num_rows($results);
$i = "0";
while ($data = mysql_fetch_array($results)) {
        $i++;
    print "<u>$data[title]</u><br>";
    print "$data[post]<br><br>";
    print DateConvert($data['posted'], "l, jS F Y @ H:i:s");
    if ($i != $rowcount) {
        print "<hr noshade size=1 color=#3366cc>";
    } else {
        unset($i);
    }
}
?>
[/code]

So thats all good, but what i also want is to be able to fetch the staff.displayname for each news_site.poster, if that makes sense.

Thanks in advance,
Dave