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
