how to make rows hoz and not vericial

[asparatu]

I would like to know how to change query output from hotizontal to vertical display, so i can print on portrait size paper.

Here is a screen shot of the report..[ATTACH]3148[/ATTACH]
Shane

[Kudose]

Without any code, we can't help much.

On that note, why don't you just print in landscape mode?

[bradgrafelman]

And if you don't want to print in landscape mode, you should search the boards for keywords such as "horizontal rows" as this topic has been covered in the past.

[asparatu]

Im trying to make as easy a posible to have them print it out. I think 15 col accross is better then having 26.

Shane
here is the code for the form

$display_block = "<table align=\"center\" width=\"200\" border=\"1\">";

while($row=mysql_fetch_assoc($result)){
   if($prev != $row['date']) {
       //close table and start new one
      $prev = $row['date'];

$display_block .= "<tr>
  <th colspan=\"26\" scope=\"col\" align=\"center\">$prev</th>
  </tr>";

$display_block .= "<tr>
  <th colspan=\"23\" scope=\"col\"></th>
  </tr>
<tr>
  <th colspan=\"2\" scope=\"col\">Information</th>
  <th colspan=\"10\" scope=\"col\">Barrels of Chemical</th>
  <th colspan=\"3\" scope=\"col\">Boxes of</th>
  <th colspan=\"8\" scope=\"col\">Supplies</th>
  </tr>
<tr>
<th scope=\"col\">Store</th>
<th scope=\"col\">Name</th>
<th scope=\"col\">TWB1</th>
<th scope=\"col\">TWB2</th>
<th scope=\"col\">TWB3</th>
<th scope=\"col\">TWB4</th>
<th scope=\"col\">WinSol</th>
<th scope=\"col\">Polish</th>
<th scope=\"col\">Bug</th>
<th scope=\"col\">CCS</th>
<th scope=\"col\">RDry</th>
<th scope=\"col\">NOil</th>
<th scope=\"col\">GC</th>
<th scope=\"col\">Dry</th>
<th scope=\"col\">DT</th>
<th scope=\"col\">TP</th>
<th scope=\"col\">HS</th>
<th scope=\"col\">CA</th>
<th scope=\"col\">WRB</th>
<th scope=\"col\">WRT</th>
<th scope=\"col\">MLR</th>
<th scope=\"col\">LRB</th>
<th scope=\"col\">CCSF</th>";
}

//Report Variables for table rows
$id = $row['id'];
$store = $row['store'];
$name = $row['name'];
$twb1 = $row['twb1'];
$twb1_bs = $row['twb1_barrel_size'];
$twb2 = $row['twb2'];
$twb2_bs = $row['twb2_barrel_size'];
$twb3 = $row['twb3'];
$twb3_bs = $row['twb3_barrel_size'];
$twb4 = $row['twb4'];
$twb4_bs = $row['twb4_barrel_size'];
$win_sol = $row['window_solution'];
$win_sol_bs = $row['window_solution_barrel_size'];
$polish = $row['polish'];
$polish_bs = $row['polish_barrel_size'];
$bug = $row['bug'];
$bug_bs = $row['bug_barrel_size'];
$ccs = $row['clear'];
$ccs_bs = $row['clear_barrel_size'];
$rdry = $row['rapid_dry'];
$rdry_bs = $row['rapid_dry_barrel_size'];
$noil = $row['noil'];
$noil_bs = $row['noil_barrel_size'];
$glass_box = $row['glass_boxes'];
$dry_box = $row['dry_boxes'];
$dash_boxes =$row['dash_boxes'];
$rolls_tp = $row['rolls_toilet_paper'];
$hs = $row['hand_soap'];
$ca = $row['clean_all'];
$wrb = $row['wiper_bag'];
$wrt = $row['rolls_wiper_tape'];
$mlr = $row['mailer'];
$lrb = $row['litterbag'];
$ccsf = $row['clear_flyers'];

$display_block .= "<tr align=\"center\">
  <td scope=\"col\">$store</td>
  <td scope=\"col\">$name</td>
  <td scope=\"col\">$twb1_total</td>
  <td scope=\"col\">$twb2_total</td>
  <td scope=\"col\">$twb3_total</td>
  <td scope=\"col\">$twb4_total</td>
  <td scope=\"col\">$win_sol/$win_sol_bs</td>
  <td scope=\"col\">$polish_total</td>
  <td scope=\"col\">$bug_total</td>
  <td scope=\"col\">$ccs_total</td>
  <td scope=\"col\">$rdry_total</td>
  <td scope=\"col\">$noil_total</td>
  <td scope=\"col\">$glass_box</td>
  <td scope=\"col\">$dry_box</td>
  <td scope=\"col\">$dash_boxes</td>
  <td scope=\"col\">$rolls_tp</td>
  <td scope=\"col\">$hs</td>
  <td scope=\"col\">$ca</td>
  <td scope=\"col\">$wrb</td>
  <td scope=\"col\">$wrt</td>
  <td scope=\"col\">$mlr</td>
  <td scope=\"col\">$lrb</td>
  <td scope=\"col\">$ccsf</td>
</tr>";
}
$display_block .= "</table>";

?>