Code: <html> <head> <link rel="stylesheet" type="text/css" href="stylesheet.css" />
<title>Paint-Zone</title> </head>
<body class="main" topmargin="0" leftmargin="0">
<div id="banner">
<? include("banner.php"); ?>
</div>
<div id="bodymenu"> <? include("menutable.php"); ?> </div>
<div id="bodycontent">
<?php $dbcnx = @mysql_connect('stuff', 'stuff', 'stuff'); if (!$dbcnx) { echo 'Unable to connect to the ' . 'database server at this time.' ; exit(); }
// Select the database if (!@mysql_select_db('paintzone')) { exit('Unable to locate the ' . 'database at this time.'); }
// Query All entries $result = @mysql_query('SELECT * FROM arena'); if (!$result) { echo ('<p>Error performing query: ' . mysql_error() . '</p>'); } else {
print $_POST['location'];
$number_of_records = mysql_num_rows($result); $name = mysql_result($result,$number_of_records-1,"name"); $location = mysql_result($result,$number_of_records-1,"location"); $number = mysql_result($result,$number_of_records-1,"number"); $email = mysql_result($result,$number_of_records-1,"email"); $summary = mysql_result($result,$number_of_records-1,"summary"); echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />';
$name = mysql_result($result,$number_of_records-2,"name"); $location = mysql_result($result,$number_of_records-2,"location"); $number = mysql_result($result,$number_of_records-2,"number"); $email = mysql_result($result,$number_of_records-2,"email"); $summary = mysql_result($result,$number_of_records-2,"summary"); echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />';
$name = mysql_result($result,$number_of_records-3,"name"); $location = mysql_result($result,$number_of_records-3,"location"); $number = mysql_result($result,$number_of_records-3,"number"); $email = mysql_result($result,$number_of_records-3,"email"); $summary = mysql_result($result,$number_of_records-3,"summary"); echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />'; } ?>
</div>
</body> </html>
|