I,m using mysql and php, i,ve created some scripts for inputting and reading data from a database,
my problem is the web pages aren,t refreshing there showing data in the tables,on the webpage that i,ve already removed from the database in mysql,can anyone help
<HTML>
<HEAD>
<!--META HTTP-EQUIV=Refresh CONTENT="10; URL=<?php print $PHP_SELF ?>"-->
<LINK REL=stylesheet TYPE="text/css" HREF="wmd.css">
<HTML>
<TITLE>reading Data from a Database</TITLE>
</HEAD>
<BODY><center>
<?php
// Set the variables for the database access:
$host="localhost";
$user="Paul";
$password="";
$database = "auction";
$TableName = "auctiondata";
$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");
$query = "SELECT * FROM auctionData";
$result = mysql_query($query)
or die ("Couldn't execute query.");
/ Display results in a table /
print ("<TABLE BORDER=1 WIDTH=\"95%\" CELLSPACING=2 CELLPADDING=2 ALIGN=CENTER>\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>AuctionId</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Name</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Item</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP> Item Description</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Startprice</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Startdate</th>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Expiresdate</th>\n");
print ("</TR>\n");
while ($row = mysql_fetch_array($result))
{
$auctionId = $row['auctionId'];
$userId = $row['userId'];
$item = $row['item'];
$itemDesc = $row['itemDesc'];
$startPrice = $row['startPrice'];
$startDate = $row['startDate'];
$expiresDate = $row['expiresDate'];
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$auctionId</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$userId</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$item</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$itemDesc</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$startPrice</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$startDate</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$expiresDate</TD>\n");
print ("</TR>\n");
}
echo "</table>\n";
mysql_close ($connection);
?>
</center>
</body>
</html>
<!--$datastring=-->
