[SOLVED] Repeating a loop

[Andrew R]

I have the following query…

 

$query_news = "SELECT * FROM news";

$news = mysql_query($query_news, $conn_aasv) or die(mysql_error());

$row_news = mysql_fetch_assoc($news);

$totalRows_news = mysql_num_rows($news);

 

do {

 

echo $row_news[‘title’];

 

} while ($row_news = mysql_fetch_assoc($news));

 

How would I reuse/repeat the above loop so I could use it on different parts of my pages, instead of having to write a new query for every one? Would I use mysql_data_seek somewhere in the script above?

 

Thanks

 

[gevans]

yes

 

mysql_data_seek($news, 0);

$row_news = mysql_fetch_assoc($news);//starts again

[Andrew R]

Thanks a million!