[Resolved] Looping problem

[sailer56]

I have a problem looping through a result set and putting the values into an array. I can either return the first or last record of about 600.

I know the $info array works because I can see the output, but only for one record. I hope I am not being completely thick about this.

Thank you in advance...
Cheers

<?
include ('db.php');
include ('class.label.php');

$labeltype="JCL20";//Av5160
$label = new Clabel($labeltype);

$result = mysql_query("SELECT first_name, last_name, str_address, suburb, city, post_code FROM member_roll ") or die ("mysql error");

while ($row = mysql_fetch_row($result)){

$fName = $row[0]; 	$lName = $row[1];
$str = $row[2];		$sub=$row[3];
$city=$row[4];		$pcode=$row[5];

$info = array($i=>array('line1'=>"$fName $lName",'line2'=>"$str", 'line3'=>"$sub",'line4'=>"$city $pcode"));	

}
$label->makeLabel($info);

//reset($info); ## just to be sure
?>😕

[gufmn]

use mysql_fetch_array() instead of mysql_fetch_row()

[sailer56]

Thanks for that but it makes no difference...

[gufmn]

Just looked at your code a little closer.

I'm assuming this line:

$label->makeLabel($info);

Is where your results are being displayed. Try putting that inside your while loop.

[sailer56]

Been there done that...

I have been going round and round for the last 2 days on this, just about pulling my hair out.

What I get is the first record displayed perfectly and nothing else. For some reason the loop is not working. If I just have the make label in the loop I get the last record displayed.

Thanks again for your time...

[gufmn]

Try doing a print_r($info) to make sure your array is being built correctly. If it is, the problem might be in your makeLabel() function.

[sailer56]

Thanks.

I now know that the correct values are available. I assume from that that I should look at the makelabel function...