Outputting the proper id

[sharpedge]

Hey Guys, I'm fairly new to PHP and mySQL but I'm trying to develop a simple little CMS system. http://www.sharpedgemedia.com/test/news.php

As you can see in the news section, I have two tables, with two rows in each, the first table gets the news_date and news_body perfectly fine from the db with the id=1 however the second table also gets the same information and doesn't get id=2 from the db. This is how I'm pulling the info in

<?php require "include/inc.setup.php";
$sql = "SELECT id, news_date, news_body from news ORDER BY id";
$result = mysql_query ($sql);
$row = mysql_fetch_assoc($result);
?>

then I'm just putting in <?=$row[news_body]?> and <?=$row[news_date]?> to output

Can anyone help me out ? Thanks

[gufmn]

Are you looping through your query results?

while($row = mysql_fetch_array($result)){
}

[sharpedge]

That was it, thanks gufmn !!!