$dbcon=mysql_connect("localhost","a0000993","itioni54");
mysql_select_db("a0000993");
$sql = 'SELECT `item` , `make` , `model` , `size` , `color` , `comments` , `email` , `entered`'
. ' FROM `exchange` '
. ' ORDER BY `entered` LIMIT 0, 30';
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
if($nrows != 0)
{
print "
If any items need to be removed, Please email Goalpost@MSN.COM
|
Used Equipment Exchange
|
| Item/Make/Model | Color/Size | Additional Comments | E-Mail Address |
|
\n";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
print "| " . $row["item"];
print " / " . $row["make"];
print " / " . $row["model"];
print " | " . $row["color"];
print " / " . $row["size"];
print " | " . $row["comments"];
print " | " . $row["email"];
print "\n";
print " |
|
\n";
}
print "