printing query result twice

[Joan Garnet]

Try this one:

Code: Select all

$temp = mysql_query("SELECT BLA BLA BLA")or die(mysql_error());
while($row = mysql_fetch_array($temp)
{
   echo $my_array[] = $row["whatever"]."<br>";
}
for ($i=0;$i<sizeof($my_array);$i++){
   echo $my_array[$i];
}