Looping Problem

humason

I am having a problem with the variables that identify the contents of an array to update within the loop. It is only showing one record of many.

Any thoughts are much appreciated.
Thanks,
Scott Humason.

while ($line = mysql_fetch_array($result, MYSQL_ASSOC))

$Account_Number = $row["Account_Number"];
$First_Name = $row["First_Name"];
$Last_Name = $row["Last_Name"];
$City = $row["City"];
$State = $row["State"];
$Country = $row["Country"];
$Contact_Phone_Ext = $row["Contact_Phone_Ext"];
$Account_Created = $row["Account_Created"];
$Account_Status = $row["Account_Status"];

{
print "\t<tr border=1>\n";
print "\t<td align=center><a href =''>$Account_Number</a></td>\n";
print "\t<td align=center>$First_Name</td>\n";
print "\t<td align=center>$Last_Name</td>\n";
print "\t<td align=center>$Phone_Number_ext</td>\n";
print "\t<td align=center>$City</td>\n";
print "\t<td align=center>$State</td>\n";
print "\t<td align=center>$Country</td>\n";
print "\t<td align=center>$Account_Created</td>\n";
print "\t<td align=center>$Account_Status</td>\n";
}

print "</tr></table>";

Anon

I think you're going to kick yourself for this one...
-------VVVVV
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))

$Account_Number = $row["Account_Number"];
------------------

humason

I think that you are talking about the two variables $line and $row. $row breaks the data out of the array($line) and it works, I just can't get it to cycle through the loop statement.

Am I on the right track with what you are trying to say? If not please clarify....

Thanks,
Scott Humason.

gmarton

Did you by any chance update to 4.2.0?
I did and now my loops dont' work. I checked the change log and it does not say anithing about it. If I revert to 4.1.2 it works fine again. If you did in fact upgrade this may also be an issue...

Anon

You need to encapsulate everything you want to loop within the curly braces {}, all of your variables are before the braces. Also you could replace all of those variable lines with one single line using the extract() function:

<?
while ($line = mysql_fetch_assoc ($result)) {
extract ($line);
...echo looped stuff here...
}
?>

Anon

Oh, okay; I must've missed that bit of code.

humason

I tried putting everything in brackets but I got the same thing over and over for the amount of rows in the query. However the extract ($line) worked like a charm. I really appreciate everyone's help.

Scott Humason.