Redundant table output

Loki · December 15, 2011, 12:01am

Hello,

Intro summary: I have coded a CSS/xHTML output display table and PHP query. It all works and W3C validates. BUT – each record displays in a new table.

The goal: I am trying to get each record to display as a row within the same table. (Code samples truncated to keep it simple.)

Hope that you all are having a good day … Loki

[php]

<?php $username="username"; $password="password"; $database="database"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM client WHERE clientSTATE='VA' ORDER BY clientNAME"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $clientNAME=mysql_result($result,$i,"clientNAME"); $clientADDRESS=mysql_result($result,$i,"clientADDRESS"); $clientCITY=mysql_result($result,$i,"clientCITY"); $clientSTATE=mysql_result($result,$i,"clientSTATE"); $clientZIP=mysql_result($result,$i,"clientZIP"); ?>

[/php]

<table>

   <tr>
<td colspan="2"><h1><?php echo $clientNAME; ?></h1></td>
   </tr>

   <tr>
<td colspan="2"><?php echo $clientADDRESS; ?></td>
   </tr>

   <tr>
<td colspan="2"><?php echo $clientCITY; ?>, <?php echo $clientSTATE; ?> <?php echo $clientZIP; ?></td>
   </tr

</table>

<?php
$i++;
}
?>

sarthakpatel · December 15, 2011, 6:52am

Hi Loki,

Take the

out of the while loop and your job is done.

As you’ve put

into while loop, for every record a new table is created.

Something like this :

[php]

<?php while(....) {?> <?php } ?>

<?php echo $clientNAME; ?>

[/php]

Loki · December 15, 2011, 2:10pm

Dear sarthakpatel,

Thank you! So obvious and I just could NOT see it. Have a great day.

Loki