3 column printing

[dlbgp]

Hi, I am trying to create a 3 column mailing label printout, with out much luck. The best I can get is a "step" print out with rec1 in row 1 col1 , rec2 in row 2 col2, rec3 in row3, col3. What I would like is: rec1 row1 col1, rec2 row1 col2, rec3 row1 col3, rec4 row2, col1 etc...... My last "ugly" version of the code is below.

Thanks!!!

<?

    while ($x<$numberall)
    {

        // Retreiving data and putting it in local variables for each row

        $firstname=mysql_result($resultall,$x,"firstname");
        $lastname=mysql_result($resultall,$x,"lastname");
        $line1=mysql_result($resultall,$x,"line1");
        $line2=mysql_result($resultall,$x,"line2");
        $city=mysql_result($resultall,$x,"city");
        $state=mysql_result($resultall,$x,"state");
        $zip=mysql_result($resultall,$x,"zip");

?>

<table border="1">
<tr>
<td width="200">
<p>
<? if ($x=='0' || $x=='3' || $x=='6' || $x=='9' || $x=='12' || $x=='15' || $x=='18' || $x=='21' ) { ?>

<? echo $firstname; ?> <? echo $lastname; ?><br>
<? echo $line1; ?> <br>
<?if ($line2) { echo $line2, "<br>" ; } ?>
<? echo $city; ?>,&nbsp; <? echo $state; ?>&nbsp;&nbsp;<? echo $zip; ?>
<? } ?>
</p>
</td>
<td width="200">

<p>
<? if ($x=='1' || $x=='4' || $x=='7' || $x=='10' || $x=='13' || $x=='16' || $x=='19' || $x=='22') { ?>

<? echo $firstname; ?> <? echo $lastname; ?><br>
<? echo $line1; ?> <br>
<?if ($line2) { echo $line2, "<br>" ; } ?>
<? echo $city; ?>,&nbsp; <? echo $state; ?>&nbsp;&nbsp;<? echo $zip; ?>
<? } ?>
</p>

</td>
<td width="200">
<p>
<? if ($x=='2' || $x=='5' || $x=='8' || $x=='11' || $x=='14' || $x=='17' || $x=='20' || $x=='23') { ?>

<? echo $firstname; ?> <? echo $lastname; ?><br>
<? echo $line1; ?> <br>
<?if ($line2) { echo $line2, "<br>" ; } ?>
<? echo $city; ?>,&nbsp; <? echo $state; ?>&nbsp;&nbsp;<? echo $zip; ?>
<? } ?>
</p>
</td>
</tr>

<?

$x++;

}} // end if numberall > 0

?>
</table>

[lucasrd]

I didn't test this, but it should get you going in the right direction, maybe it will even work first try 🙂

<?

echo "<table border=\"1\">\n";


$x = 0;
$colsPerRow = 3;

while ($x<$numberall)
{

// Retreiving data and putting it in local variables for each row

$firstname=mysql_result($resultall,$x,"firstname");
$lastname=mysql_result($resultall,$x,"lastname");
$line1=mysql_result($resultall,$x,"line1");
$line2=mysql_result($resultall,$x,"line2");
$city=mysql_result($resultall,$x,"city");
$state=mysql_result($resultall,$x,"state");
$zip=mysql_result($resultall,$x,"zip");

//Start a new row on every $colsPerRow record ************
if($x%$colsPerRow == 0) echo "<tr>";

//Print out a cell *********************************
echo "<td width=\"200\">";

   echo $firstname . " " . $lastname; . "<br>";
   echo $line1 . "<br>";
   if (trim($line2)) { 
      echo $line2, "<br>" ; 
   } 
  echo $city . ", " . $state . "  " . $zip;

echo "</td>";

if( (($x+1) % $colsPerRow) == 0) echo "</tr>";

$x++;

}

//Fill in any empty cells when the loop ends **************
if($x%3 != 0){
   while($x%$colsPerRow != 0){
      echo "<td>&nbsp;</td>";
      $x++;
   }   

   echo "</tr>";
}

//End the table ***************************************
echo "</table>";

?>

[dlbgp]

Thanks for the fast response, needed just a few tweaks!!!!!!

[lucasrd]

so did you get it working? what did you need to tweak?

[dlbgp]

This line:
echo "<td width=\"200>";

And added one } at the end...

Thanks again.........