[SOLVED] Return more rows

[Imtehbegginer]

<?php

 

include('includes/config.php');

 

$connect = mysql_connect($config['host'], $config['user'], $config['pass']);

$database = mysql_select_db($config['name']);

 

$query = mysql_query("SELECT * FROM rosecms_news");

 

$news = mysql_fetch_array($query);

 

echo '<H1>'.$news['title'].'</h1>';

echo $news['date'];

echo '<BR>';

echo '<BR>';

echo $news['content'];

?>

 

That is my code above... how can I return the next set of data?

 

If I re-do the script, it returns the exact same data.

[marcus]

while($news = mysql_fetch_array($query)){
echo '<H1>'.$news['title'].'</h1>';
echo $news['date'];
echo '<BR>';
echo '<BR>';
echo $news['content'];
echo "<br><br>\n";
}

 

in replace of:

 

$news = mysql_fetch_array($query);

echo '<H1>'.$news['title'].'</h1>';
echo $news['date'];
echo '<BR>';
echo '<BR>';
echo $news['content'];

[Imtehbegginer]

That was a really fast reply. Thanks!

[marcus]

Fo sho.