Okay, I feel like an idiot, but.....

[ttnyc3]

This is driving me batty!!!!!

I need to loop through a mysql result set and print one line for each row. Pretty simple huh! Well I am stumped. The code below produces one (the last) row. On a good note it is printing correctly formatted and accurately. Got any suggestions?

<?
$query = "select rid, rt_num, rt_name from route_lu where cid = ";
$query .= $SESSION['cid'];
$result = mysql_query($query );
$row = mysql_fetch_array($result );
$numrows = mysql_num_rows($result);
$subrow = 1;
while ( $row = mysql_fetch_array($result) )
{
$pline = "Menu1";
$pline .= $subrow;
$pline .= "=new Array(\"";
$pline .= $row['rt_name'];
$pline .= "\",\"#\",\"\",0,20,190,\"white\",\"black\",\"black\",\"white\",\"888888\",\"\",-1,-1,-1,\"\",\"\")";
print ($pline);
$subrow ++;

}	

?>

[corruption]

This is a script i've been working on. It seems similar to yours, and i've got it to print one line per row.

<?php
echo "<tr>";
$i = 0;
  while($row = mysql_fetch_array($result))
  {
$i++;
if($i == 1) {
}
echo "<td width=\"20%\" align=\"center\" valign=\"top\">";
      echo "<a href=profile.php?brother_id=".$row['brother_id'].">";
echo $row['fname']." ".$row['lname'];
       echo "</a>"; 
echo "</td>[COLOR=crimson]More <td> tags here for more information on row[/COLOR] </tr>";
  }
if($i == 3) {
echo "</tr>";
$i = 0;

}
} 
    else
    {
    echo "No rows returned!";
    }

?>

I hope that's a good enough example that can help you.

[ttnyc3]

Oh My God!!! Duh, Duh Duh! Look at line 4, I'm calling mysql_fetch_array($result) twice. Thanks for your help though.

T