include("config/db.php");
$connection=mysql_connect($dbHost,$dbUser,$dbPass);
$db = mysql_select_db($dbDatabase, $connection);
$sql = "select paypal, header1, header2, email, phone, person, payment_paypal,
payment_check, payment_cc_phone, address, city, state, zip from ".$table."web";
$result = mysql_query($sql) or die($sql . mysql_error());
while ($row = mysql_fetch_row($result))
{
$paypal = $row[0];
$header1 = $row[1];
$header2 = $row[2];
$email = $row[3];
$phone = $row[4];
$person = $row[5];
$pp = $row[6];
$pc = $row[7];
$pcp = $row[8];
$address = $row[9];
$city = $row[10];
$state = $row[11];
$zip = $row[12];
}
$username = explode("_",$table);
$sql = "select header, footer from webpages where username = '".$username[0]."'";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result))
{
$header = $row[0];
$footer = $row[1];
}
function format($datea)
{
if ($datea <> "" or !empty($datea)) {
list($year, $month, $day) = explode("-",$datea);
$dateb = $month . "/". $day . "/". $year . " ";
return $dateb;
}
else
{ $dateb = ""; return $dateb; }
}
?>
print $header; ?>
print $header1; print "
"; ?>
print $header2; print "
"; ?>
Class | |
$title - $$cost "; print "$timeinfo "; if ($date1) { print "Class Dates: $date1 $date2 $date3 $date4 $date5 $date6 $date7 $date8 $date9 $date10 $date11 $date12 "; } print " $desc"; $sqlenr = "select count(*) from ". $table . "roster where classid = $classid"; $enrolled = 0; $resultenr = mysql_query($sqlenr) or die($sqlenr); while ($myrowenr = mysql_fetch_row($resultenr)) { $enrolled = $myrowenr[0]; } $avail = $maxdogs - $enrolled; print " | Spaces available: $avail Sign Up"; } // print the contact information here ?> |
Contact Information
$person
$email
$phone
$address
$city $state $zip
Powered by EdogTrainer.com print $footer; ?>