can i do 2 while loops for the results of 1 SELECT statement?

[busby]

here is some simple code for getting and displaying fata from a database

 

$sql="SELECT * FROM messages WHERE m_id = '".$id."'";

$result = mysql_query($sql);

<table border='0' cellspacing="4">

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<th>Message</th>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>" . $row['message'] . "</td>";
  echo "</tr>";
  }

 

now ive used that while loop to display those results how can i do that again without having a new SQL statement.

 

i cant do 2 while loops because the first one has already got to the end of the amount of rows

 

basically how can i have another while loop displaying those same results again?

[BlueSkyIS]

you can. one way is to use mysql_data_seek to set the result pointer back to the first result:

 

} // end first loop

mysql_data_seek($result,0);

while ($data = mysql_fetch_array($result)) { // start second loop

[busby]

excellent! thankyou  exactly what i was looking for and such a simple solution.