Change the design of the HTML table.
> [Original Message] > From: BigMark <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Date: 06/04/2004 8:07:51 PM > Subject: [PHP] table formatting > > This script by Rob Sossomon works great --Thanks! > however could anyone tell me if its possible to make it run horizontally. at > the moment the output is like this--- > > ---------------------------------------------- > Round Game Winning team Wins > 1 1 Collingwood > 1 2 Melbourne 4 > 1 3 Fremantle 4 > 1 4 Brisbane 4 > 1 5 St Kilda > 1 6 Port Adelaide 4 > 1 7 Kangaroos 4 > 1 8 West Coast 4 > 2 1 Richmond > 2 2 Collingwood 4 > 2 3 Brisbane 4 > 2 4 West Coast > 2 5 Essendon > 2 6 Fremantle > 2 7 Carlton 4 > 2 8 Hawthorn > > ----------------------------------------------------------I would like it > like this > Round game1 win game2 win game3 etc > > 1 Collingwood 4 Melbourne 4 Fremantle 4 > > > <?php > session_start(); > include("connect.php"); > $Name = $_SESSION['first_name'] . " " . $_SESSION['last_name']; > > $sql = "SELECT * FROM Selections WHERE Name = '$Name'"; > $result = mysql_query($sql); > > /* Determine the number of records returned */ > while ($row = MYSQL_FETCH_array($result)) > $number = mysql_numrows($result); > > > /* Start printing to make it look good */ > print "<table width=\"30%\" cellspacing=\"0\" cellpadding=\"0\" > border=\"0\">"; > print > "<tr><th>Round....</th><th>Game....</th><th>Winning > Team....</th><th>Wins</th></tr>"; > > $total_points=0; > /* Iterate through to make it clean */ > while ($i < $number) > { > $item_1 = mysql_result($result, $i,"Round"); > $item_2 = mysql_result($result, $i,"Game"); > $item_4 = mysql_result($result, $i,"Winner"); > $item_5 = mysql_result($result, $i,"Points"); > > /* This makes it print out in 2 separate color, depending on rows. */ > if ($i%8 == 0) > { > print "<tr > bgcolor=\"#999999\"><td><center>$item_1</center></td><td><center>$item_2</ce > nter></td><td><center>$item_4</center></td><td><center>$item_5</center></td> > </tr>\n"; > } > else > { > print "<tr > bgcolor=\"#666666\"><td><center>$item_1</center></td><td><center>$item_2</ce > nter></td><td><center>$item_4</center></td><td><center>$item_5</center></td> > </tr>\n"; > } > > > > /* Increase record count and total_points to date */ > $i++; > $total_points += $item_5; > } > /* close everything up */ > > print "<tr><th colspan=5>Total Points Earned: $total_points</th></tr>"; > print "</table>"; > > ?> > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php