// This page will list all of the items
// from the items table. Each item will have
// a link to add it to the cart
// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
if(ereg("staging",$_SERVER['HTTP_HOST'])) {
$regstatus="(regstatus='0' or regstatus='2')"; }
else {
$regstatus="(regstatus='0')"; }
$result = mysql_query("select * from inventory where itemid='$event' and $regstatus");
while($row = mysql_fetch_array($result)) {
?>
if(mysql_num_rows($result)=="0"){ ?>On-line registration for this event is currently not available. } ?>
if($failed){ ?>Error
if($pricetype=="") { ?>
Select the price you wish to purchase this book with.
} ?>
if($nomemid){ echo "
A member ID, which may be found on your AIGA Membership Card, is required if requesting a member discount. Select the published price if you're not an AIGA member.