'$todaydate' AND event_type = 8 order by dateformal";
//echo $eventsql;
$eventresult=mysql_query($eventsql) or die(mysql_error());

if ($_GET["themess"]) { echo "

".$_GET["themess"]."

"; }
?>

Welcome to The Kindlings Muse Special Event Registration


Please select an event (required):

";?>

"; ?>

";
$sumeventsql="SELECT SUM(num_party) FROM registration WHERE event_ID='".$rowevent["ID"]."' ";
$sumeventresult=mysql_query($sumeventsql) or die(mysql_error());
$sumeventrow=mysql_fetch_array($sumeventresult);
$regclosednum=$rowevent["seats"]-$sumeventrow[0];
if ($sumeventrow[0] > $rowevent["seats"]-1) {
if ($SPshowfulltoguest=="1") {
$regclosed="
".$SPshowfulltext."";
}
}
else {
if ($SPshowseatedtoguest=="1") {
$regclosed= "
      ".$SPshowseatedtext.": $regclosednum";
}
}
?>

" name="getevents[]">


First Name: (required)
Last Name: (required)
Your Email Address: (required)
Student?
If Student, School?
Number you are
registering:
(required)
Your guests email(s)
separated by commas
( if available)
Comments: