[Nickeh32]

I'm making my own news system, i am having a problem showing the second table, it will only show one.
my code:

//selecting the 'news' database to use 
    mysql_select_db("news");
	
//Get todays date 
    $today = date("l F dS Y"); 
	
// create sql statement
$query="SELECT * FROM news";
$result=mysql_query($query);

// total row number
$num=mysql_numrows($result);

// news fieds
$title=mysql_result($result,$i,"title");
$news=mysql_result($result,$i,"news");

I know it's simple, but i'm quite new to this.
Can anyone help?