call the function twice?

[smartic]

I'm having problem with this code i can't describe the problem, that is my code:

[PHP]<?php
$announce = mysql_query("SELECT * FROM announce LIMIT 4");
while($key = mysql_fetch_assoc($announce)){
echo '<td style="border:#999999 solid 1px;"><center>'.$key['Title'].'</center></td>';
}
?>
</tr>
<tr>
<?php
while($key = mysql_fetch_assoc($announce)){
for($i=1;$i<=3;$i++){
$PicArray = 'Pic'.$i;
if($key[$PicArray]!=''){
$PicType = explode(',',$key[$PicArray]);
$tum = $PicType[1];
if(is_file($tum)){
echo '<td style="border:#999999 solid 1px;"><center><img src="'.$tum.'"/></center></td>';
break;
}
}
}
}
?>[/PHP]

in this code to solve it i have to call this function again in the second row why?

[PHP]$announce = mysql_query("SELECT * FROM announce LIMIT 4");[/PHP]

[Atli]

The result returned by the mysql_query() function keeps an internal row pointer, which is incremented whenever you call a mysql_fetch_*() function on it.

So after the first loop has completed, the internal pointer has already reached the end of the result set, so any mysql_fetch_*() call will fail on it.

Try using the mysql_data_seek function on it before the second loop. Like:

$result = mysql_query("SELECT cols FROM tbl");
while($row = mysql_fetch_assoc($result)) {#...}
 
mysql_data_seek($result, 1);
while($row = mysql_fetch_assoc($result)) {#...}