mysql fetch array loop help

[willl]

Hi there,

I have a problem with this code. It will terminate the first 'while loop' perfectly, however not the second!!

Here it is:

$query = "SELECT * from company_ins, company_log WHERE company_ins.ins_id = '$typeid'
			AND company_log.Id = company_ins.company_Id order by company_log.name";

$result = mysql_query($query, $conn);			

//check for any featured providers
while ($row = mysql_fetch_array($result, $conn)) {

if ($row['type_featured'] == "f") {
?>
<div class="linkbox">
		FEATURED<a href="<?php echo $row['link']; ?>" class="link" target="_blank"><strong><?php echo $row['name']; ?></strong></a>
	<p><?php echo $row['description']; ?><p><a href="<?php echo $row['link']; ?>" target="_blank"><?php echo $row['link']; ?></a></p>
</div>
<?php 
	}
}



while ($row = mysql_fetch_array($result, $conn)) {

if ($row['type_featured'] !='f') {

?>
<div class="linkbox">
		<a href="<?php echo $row['link']; ?>" class="link" target="_blank"><strong><?php echo $row['name']; ?></strong></a>
	<p><?php echo $row['description']; ?><p><a href="<?php echo $row['link']; ?>" target="_blank"><?php echo $row['link']; ?></a></p>
</div>
<?php 
	}
}
 ?>

Any ideas,

Many thanks!

Will

[bbreslauer]

Heh, this one tripped me up the first time I did it too 🙂

The problem is that the while loop runs through until mysql_fetch_array has no more records to output, so it exits. You would think that running mysql_fetch_array again would get the records again, but that's not in fact the case. The pointer that was being advanced each time through the loop is in $result, so $result is at it's end. You need to redo the query (just repeat $result= before the second while loop) and you should be all set.

[willl]

ah, thanks very much.

Will

[rincewind456]

Or much simpler would be to use mysql_data_seek() to reset the pointer to the start of the array.
like

mysql_data_seek{$result,0);

[bbreslauer]

ooo, reset(), that would be much better, forgot about that.