Auto load data
| From: | ascll | Date: | Tue, 23 Sep 2003 01:44:59 +0000 |
| Subject: | Auto load data | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-163532@lists.php.net to get a copy of this message | ||
Greetings,
I'm designing a table with 21 columns and 3 rows (1-row column header, 2-row
data) store in .php file, and each cell of this table storing a value, that
I stored it using MySQL database. Now, I want all the values (just the
values, but NOT the table) shown on this page automatic update every
1-second.
So, I use "create_table.php" to create the table and automatic load
"get_data.php" every 1-second to retrieve data from database. Once the
"get_data.php" loaded, my IE only show those data and the table disappeared.
Please help. Thanks in advance.
========== start create_table.php ============
<html>
<head>
<title>Member Area</title>
<META HTTP-EQUIV=Refresh CONTENT="5; URL=get_data.php">
</head>
<body>
<center>
<table bgcolor="#EEEEEE" border="0"
width="95%"><tr><td>
<table bgcolor="#B6C7E5" border="0"
width="100%"><tr><td>
<table bgcolor="#FFFFFF" border="0"
width="100%"><tr><td>
<table border=0 bgcolor="#F7F7FF" width="100%">
<tr><th colspan=21><font size=+1>RACING
RESULT</font></td></tr>
<tr bgcolor="#FFFFFF"><th colspan=21></tr>
<tr>
<td width="20%">1st row</td><td
width="4%">1</td><td
width="4%">2</td><td width="4%">3</td><td
width="4%">4</td>
<td width="4%">5</td><td
width="4%">6</td><td width="4%">7</td><td
width="4%">8</td><td width="4%">9</td>
<td width="4%">10</td><td
width="4%">11</td><td
width="4%">12</td><td width="4%">13</td><td
width="4%">14</td>
<td width="4%">15</td><td
width="4%">16</td><td
width="4%">17</td><td width="4%">18</td><td
width="4%">19</td><td
width="4%">20</td>
</tr>
<tr>
<td width="20%">2nd row</td><td width="4%">' .
$myWin1 . '</td><td
width="4%">' . $myWin2 . '</td><td width="4%">' .
$myWin3 . '</td>
<td width="4%">' . $myWin4 . '</td><td
width="4%">' . $myWin5 .
'</td><td width="4%">' . $myWin6 . '</td><td
width="4%">' . $myWin7 . '</td>
<td width="4%">' . $myWin8 . '</td><td
width="4%">' . $myWin9 .
'</td><td width="4%">' . $myWin10 . '</td><td
width="4%">' . $myWin11 .
'</td>
<td width="4%">' . $myWin12 . '</td><td
width="4%">' . $myWin13 .
'</td><td width="4%">' . $myWin14 . '</td><td
width="4%">' . $myWin15 .
'</td>
<td width="4%">' . $myWin16 . '</td><td
width="4%">' . $myWin17 .
'</td><td width="4%">' . $myWin18 . '</td><td
width="4%">' . $myWin19 .
'</td>
<td width="4%">' . $myWin20 . '</td>
</tr>
<tr>
<td width="20%">3rd row</td><td width="4%">' .
$myPlace1 .
'</td><td width="4%">' . $myPlace2 . '</td><td
width="4%">' . $myPlace3 .
'</td>
<td width="4%">' . $myPlace4 . '</td><td
width="4%">' . $myPlace5
. '</td><td width="4%">' . $myPlace6 . '</td><td
width="4%">' . $myPlace7 .
'</td>
<td width="4%">' . $myPlace8 . '</td><td
width="4%">' . $myPlace9
. '</td><td width="4%">' . $myPlace10 . '</td><td
width="4%">' . $myPlace11
. '</td>
<td width="4%">' . $myPlace12 . '</td><td
width="4%">' .
$myPlace13 . '</td><td width="4%">' . $myPlace14 .
'</td><td width="4%">' .
$myPlace15 . '</td>
<td width="4%">' . $myPlace16 . '</td><td
width="4%">' .
$myPlace17 . '</td><td width="4%">' . $myPlace18 .
'</td><td width="4%">' .
$myPlace19 . '</td>
<td width="4%">' . $myPlace20 . '</td>
</tr>
</table>
</td></tr></table>
</td></tr></table>
</td></tr></table>
</center>
</body>
</html>
========== end create_table.php ============
========== start get_data.php ============
<?php
$result = @mysql_query('SELECT
myWin1, myWin2, myWin3,
myWin4,
myWin5, myWin6, myWin7, myWin8,
myWin9, myWin10, myWin11,
myWin12, myWin13, myWin14, myWin15,
myWin16, myWin17, myWin18,
myWin19, myWin20, myPlace1, myPlace2,
myPlace3, myPlace4,
myPlace5, myPlace6, myPlace7, myPlace8,
myPlace9, myPlace10,
myPlace11, myPlace12, myPlace13, myPlace14,
myPlace15,
myPlace16, myPlace17, myPlace18, myPlace19,
myPlace20 FROM
Testing');
if (!$result) {
die('<p>Error performing query: ' . mysql_error() . '</p>');
}
while ( $row = mysql_fetch_array($result) )
{
$myWin1 = $row['0'];
$myWin2 = $row['1'];
$myWin3 = $row['2'];
$myWin4 = $row['3'];
$myWin5 = $row['4'];
$myWin6 = $row['5'];
$myWin7 = $row['6'];
$myWin8 = $row['7'];
$myWin9 = $row['8'];
$myWin10 = $row['9'];
$myWin11 = $row['10'];
$myWin12 = $row['11'];
$myWin13 = $row['12'];
$myWin14 = $row['13'];
$myWin15 = $row['14'];
$myWin16 = $row['15'];
$myWin17 = $row['16'];
$myWin18 = $row['17'];
$myWin19 = $row['18'];
$myWin20 = $row['19'];
$myPlace1 = $row['20'];
$myPlace2 = $row['21'];
$myPlace3 = $row['22'];
$myPlace4 = $row['23'];
$myPlace5 = $row['24'];
$myPlace6 = $row['25'];
$myPlace7 = $row['26'];
$myPlace8 = $row['27'];
$myPlace9 = $row['28'];
$myPlace10 = $row['29'];
$myPlace11 = $row['30'];
$myPlace12 = $row['31'];
$myPlace13 = $row['32'];
$myPlace14 = $row['33'];
$myPlace15 = $row['34'];
$myPlace16 = $row['35'];
$myPlace17 = $row['36'];
$myPlace18 = $row['37'];
$myPlace19 = $row['38'];
$myPlace20 = $row['39'];
echo('<tr><td width="20%">2nd row</td><td
width="4%">' . $myWin1 . '</td><td
width="4%">' . $myWin2 . '</td><td width="4%">' .
$myWin3 . '</td>
<td width="4%">' . $myWin4 . '</td><td
width="4%">' . $myWin5 . '</td><td
width="4%">' . $myWin6 . '</td><td width="4%">' .
$myWin7 . '</td>
<td width="4%">' . $myWin8 . '</td><td
width="4%">' . $myWin9 . '</td><td
width="4%">' . $myWin10 . '</td><td width="4%">' .
$myWin11 . '</td>
<td width="4%">' . $myWin12 . '</td><td
width="4%">' . $myWin13 . '</td><td
width="4%">' . $myWin14 . '</td><td width="4%">' .
$myWin15 . '</td>
<td width="4%">' . $myWin16 . '</td><td
width="4%">' . $myWin17 . '</td><td
width="4%">' . $myWin18 . '</td><td width="4%">' .
$myWin19 . '</td>
<td width="4%">' . $myWin20 . '</td></tr>');
echo('<tr><td width="20%">3rd row</td><td
width="4%">' . $myPlace1 .
'</td><td width="4%">' . $myPlace2 . '</td><td
width="4%">' . $myPlace3 .
'</td>
<td width="4%">' . $myPlace4 . '</td><td
width="4%">' . $myPlace5 .
'</td><td width="4%">' . $myPlace6 . '</td><td
width="4%">' . $myPlace7 .
'</td>
<td width="4%">' . $myPlace8 . '</td><td
width="4%">' . $myPlace9 .
'</td><td width="4%">' . $myPlace10 . '</td><td
width="4%">' . $myPlace11 .
'</td>
<td width="4%">' . $myPlace12 . '</td><td
width="4%">' . $myPlace13 .
'</td><td width="4%">' . $myPlace14 . '</td><td
width="4%">' . $myPlace15 .
'</td>
<td width="4%">' . $myPlace16 . '</td><td
width="4%">' . $myPlace17 .
'</td><td width="4%">' . $myPlace18 . '</td><td
width="4%">' . $myPlace19 .
'</td>
<td width="4%">' . $myPlace20 . '</td></tr>');
}
?>
========== end get_data.php ============