Help with table joins

[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

[fenway]

Well, you're asking for "*" -- all the fields in both tables. This may be troublesome if there are column name collisions. You should explicity refer to the columns you want, and alias them as necessary. In your case, it seems like you be doing:

[code]SELECT news_site.title, news_site.post, news_site.data, staff.displayname.....[/code]