Problem Displaying Results from Query

[AKalair]

Hi,

 

When I display the results from this query the title and tagline changes but the image displayed is always the same despite having different images stored in the database.

 

$getlateststories = mysql_query("SELECT * FROM reviews, news ORDER BY 'creationdate' LIMIT 0, 2 ") or trigger_error('Unable to get latest stories', E_USER_ERROR);



while($Results = mysql_fetch_array($getlateststories))  

{

echo "<p class=Headings> <a href=/viewnewsstory.php?newsid=$Results[newsid]&catid=$Results[categoryid]>$Results[newstitle] </p></a> <img src=$Results[imageurl]> <br> <p class=Sub_Headings>$Results[newstagline]</p><br><br>  ";  
echo "<p class=Headings> <a href=/viewreviews.php?reviewid=$Results[reviewid]&catid=$Results[categoryid]>$Results[reviewtitle] </p></a> <img src=$Results[imageurl]> <p class=Sub_Headings>$Results[reviewtagline] </p><br><br>  ";
}

 

Any ideas?

 

Thanks

[fenway]

Yikes... where's the join condition.