Trying to loop the output

Worker Joined: Sep 09, 2003 Posts: 165

I am working on a company database that is webbased
So far i got it to work but only displays 1 record

Code:

$result = mysql_query("SELECT * FROM `customers` WHERE `Name`", $connection);


      echo "<TABLE BORDER=1>";


       echo "<TR><TH>NAME<TH>ADDRESS<TH>CITY<TH>TOWER<TH>TOWER SECTOR<TH>CPE MAC";





       /* format results by row */


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


           $nam = $row["Name"];


      $add = $row["Address"];


      $cit = $row["City"];


      $tow = $row["Tower"];


      $tsa = $row["Tower Sector Abbrev"];


      $cpemac = $row["CPE MAC"];


          echo "<TR><TD>$nam<TD>$add<TD>$cit<TD>$tow<TD>$tsa<TD>$cpemac";

This is what i have so far it does what it is suppose to do but doesnt display more than 1 record not sure where to go from here. I want it to show all the records there is about 1200 of them
Thanks
Rick

Posted: Mon Nov 15, 2004 8:45 pm

I figured it out

Before

Code:

$result = mysql_query("SELECT * FROM `customers` WHERE `Name`", $connection); 


      echo "<TABLE BORDER=1>"; 


       echo "<TR><TH>NAME<TH>ADDRESS<TH>CITY<TH>TOWER<TH>TOWER SECTOR<TH>CPE MAC"; 





       /* format results by row */ 


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


           $nam = $row["Name"]; 


      $add = $row["Address"]; 


      $cit = $row["City"]; 


      $tow = $row["Tower"]; 


      $tsa = $row["Tower Sector Abbrev"]; 


      $cpemac = $row["CPE MAC"]; 


          echo "<TR><TD>$nam<TD>$add<TD>$cit<TD>$tow<TD>$tsa<TD>$cpemac";








After





$result = mysql_query("SELECT * FROM `customers` WHERE 1", $connection); 


      echo "<TABLE BORDER=1>"; 


       echo "<TR><TH>NAME<TH>ADDRESS<TH>CITY<TH>TOWER<TH>TOWER SECTOR<TH>CPE MAC"; 





       /* format results by row */ 


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


           $nam = $row["Name"]; 


      $add = $row["Address"]; 


      $cit = $row["City"]; 


      $tow = $row["Tower"]; 


      $tsa = $row["Tower Sector Abbrev"]; 


      $cpemac = $row["CPE MAC"]; 


          echo "<TR><TD>$nam<TD>$add<TD>$cit<TD>$tow<TD>$tsa<TD>$cpemac";

Sorry

posted this for future reference

Thanks
Rick