php code is producing double results - why?

willl

I am using this code to pull data out of 2 tables:

$query = mysql_query("SELECT date_format(link_log.added,'%D %M %Y'), url AS added, url 
     FROM link_log INNER JOIN link_company ON  link_log.company_id = ".$company_id." 
     ORDER BY added DESC") or exit(mysql_error());  

echo "<table cellspacing=\"4\" cellpadding=\"2\">\n";

echo "<tr><td><b>Date page was viewed</b></td><td><b>Page viewed</b></td></tr>";

while($row = mysql_fetch_array($query)) {
echo "<tr><td>".$row[0]."</td><td>".$row['url']."</td></tr>\n";
}

And it is pulling out and printing each row twice!

Can anyone see what the problem is??

Thanks in advance

Will

Roger_Ramjet

The problem is in your Join - or rather your lack of one. You are not specifying the join condition correctly, so you get every row joined to every row, hence your duplication of rows in the resultset.

$query = mysql_query("SELECT date_format(link_log.added,'%D %M %Y') AS added, url
     FROM link_log INNER JOIN link_company ON  link_log.company_id = link_company.company_id 
     WHERE link_log.company_id=".$company_id."
     ORDER BY link_log.added DESC") or exit(mysql_error());

willl

Roger - spot on,

Thanks again.