Displaying content of database
Posted: Thu Feb 18, 2010 9:11 am
I am new to php and am trying to create an interface to allow users to view and update a database.
I have used the following code from a tutorial modified for my database, but the display obtained is a vertical table of each record rather than the spreadsheet view I was looking for.
The html section showing the column headers appears at the bottom of the display rather than the top.
I would be grateful for any advice on how to achieve the desired result.
Thanks
Dave
<?
$username="bnsquash";
$password="can1squash";
$database="bnsquash_courttime";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM courttimes";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$Day=mysql_result($result,$i,"Day");
$Date=mysql_result($result,$i,"Date");
$Time1=mysql_result($result,$i,"Time1");
$Player1=mysql_result($result,$i,"Player1");
$Player2=mysql_result($result,$i,"Player2");
$Time2=mysql_result($result,$i,"Time2");
$Player3=mysql_result($result,$i,"Player3");
$Player4=mysql_result($result,$i,"Player4");
echo "<b>Day: $Day</br><br> Date: %Date</b><br>Time1: $Time1<br>Player1: $Player1<br>Player2: $Player2<br>Time2: $Time2<br>Player3: $Player3<br>Player4:$Player4<br><hr><br>";
$i++;
}
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Day</font></th>
<th><font face="Arial, Helvetica, sans-serif">Date</font></th>
<th><font face="Arial, Helvetica, sans-serif">Time1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Time2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player3</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player4</font></th>
</tr>
I have used the following code from a tutorial modified for my database, but the display obtained is a vertical table of each record rather than the spreadsheet view I was looking for.
The html section showing the column headers appears at the bottom of the display rather than the top.
I would be grateful for any advice on how to achieve the desired result.
Thanks
Dave
<?
$username="bnsquash";
$password="can1squash";
$database="bnsquash_courttime";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM courttimes";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$Day=mysql_result($result,$i,"Day");
$Date=mysql_result($result,$i,"Date");
$Time1=mysql_result($result,$i,"Time1");
$Player1=mysql_result($result,$i,"Player1");
$Player2=mysql_result($result,$i,"Player2");
$Time2=mysql_result($result,$i,"Time2");
$Player3=mysql_result($result,$i,"Player3");
$Player4=mysql_result($result,$i,"Player4");
echo "<b>Day: $Day</br><br> Date: %Date</b><br>Time1: $Time1<br>Player1: $Player1<br>Player2: $Player2<br>Time2: $Time2<br>Player3: $Player3<br>Player4:$Player4<br><hr><br>";
$i++;
}
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Day</font></th>
<th><font face="Arial, Helvetica, sans-serif">Date</font></th>
<th><font face="Arial, Helvetica, sans-serif">Time1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Time2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player3</font></th>
<th><font face="Arial, Helvetica, sans-serif">Player4</font></th>
</tr>