endless loop help

[Darkmatter5]

Why would

$row=mysql_fetch_assoc($result);
echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($row) {
  echo "<li><a href='editjobs.php?=" .$row['job_id']. "' >" .$row['job_number']. "</a>, " .$row['job_desc']. "</li>";
}
echo "</ol></td></tr></table>";

create an endless loop that prints out the <li> line endlessly, while

echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($row=mysql_fetch_assoc($result)) {
  echo "<li><a href='editjobs.php?=" .$row['job_id']. "' >" .$row['job_number']. "</a>, " .$row['job_desc']. "</li>";
}
echo "</ol></td></tr></table>";

only outputs the specified results and the loop ends correctly?

[Guardian-Mage]

$row=mysql_fetch_assoc($result);
echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($m = $row) {
  echo "<li><a href='editjobs.php?=" .$m['job_id']. "' >" .$m['job_number']. "</a>, " .$m['job_desc']. "</li>";
}
echo "</ol></td></tr></table>";

[TempleDMDKrazd]

because the first one

 

while($row)

{

}

 

is always TRUE!!! it stays on the first row....you're not fetching any new rows in that loop...

 

try

 

print_r($row); // it should give the same variables over and over

 

 

and the second one...after it finishes the loop body it goes back to the while condition and $row is assigned a new one...when there arent any more rows mysql_fetch_assoc() return false...

[Darkmatter5]

Guardian-Mage,

I tried your idea and I got the same result.

 

TempleDMDKrazd,

Can you include the print_r($row) code in my code so I know exactly what you mean. I've tried a few things, but it didn't seem to work?

 

Thanks for the replies!

[samshel]

$row=mysql_fetch_assoc($result);
echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($m = $row) {
  echo "<li><a href='editjobs.php?=" .$m['job_id']. "' >" .$m['job_number']. "</a>, " .$m['job_desc']. "</li>";
}
echo "</ol></td></tr></table>";

 

even this is endless.

try this..

echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($row=mysql_fetch_assoc($result) {
  echo "<li><a href='editjobs.php?=" .$m['job_id']. "' >" .$row['job_number']. "</a>, " .$m['job_desc']. "</li>";
}
echo "</ol></td></tr></table>";

[TempleDMDKrazd]

$row=mysql_fetch_assoc($result);

while($row) {
print_r($row); //this should print the same thing over and over because its the same row you are not fetching any new rows
}

 

[TempleDMDKrazd]

to make the first one work is very simple..

 

$row=mysql_fetch_assoc($result);
echo "<table width='650' border='0'>";
echo "<tr>";
echo "<td colspan='2' class='row_description' align='left'>";
echo "<ol>";
while($row) {
  echo "<li><a href='editjobs.php?=" .$row['job_id']. "' >" .$row['job_number']. "</a>, " .$row['job_desc']. "</li>";
  $row=mysql_fetch_assoc($result); // just add this inside the loop
}
echo "</ol></td></tr></table>";

 

add this line inside the while loop which i did for you

$row=mysql_fetch_assoc($result)

[Darkmatter5]

Excellent TempleDMDKrazd!! Add that one line did the trick!! Thank you!

[d.shankar]

Click "Topic Solved" please.