Reset on a mysql result?

[suttercain]

Hi guys, I am trying to reset a MySQL result so I can echo out the first result twice. I can't get it to work right...

 

<?php
	 $comics = mysql_query("SELECT * FROM comics ORDER BY comic_id DESC LIMIT 0, 10") or die(mysql_error());
	 $list = mysql_fetch_assoc($comics);
	 reset($list);
         echo "<a href='comics/".$list['comic_id']."/'>";
	 echo "<img src=\"images/4ndvddb/medium/".$list['cover_art']."\" alt=\"".$list['title']."\" style='border:1px solid #ccc;padding:3px;float:left;margin:3px;'/>"; //Echo the first result (okay)
	 echo "</a>";
	 echo "<div style='float:left;'>";

	 while ($list = mysql_fetch_array($comics)) {
	 echo $list['comic_id']; //Trying to echo the first result again, but it starts after the first one
	 echo "<br />";
	 }
	 echo "</div>";
	 ?>

[trq]

mysql_data_seek() is the function your looking for. Your want to reset the result resource itself, not one of the arrays produced by mysql_fetch_assoc.

[hitman6003]

Use the seek functions...

 

http://www.php.net/mysql_data_seek