defineDBType("mySQL");
$display_db->setCon($db_hostname, $db_username, $db_password);
$display_db->setDB("tasoaustindb");
$display_db->dbConnect();
$display_db->selectDb();
// $display_query = "SELECT * FROM clinics WHERE ae_id = '" . $_REQUEST["ae_id"] . "'";
$display_query = "SELECT * FROM clinics WHERE ae_id = '5'";
$display_db->setQuery($display_query);
$display_db->runQuery();
while($display_result = $display_db->sqlFetchArray()){
$display_ae_id = $display_result["ae_id"];
$display_event_title = $display_result["event_title"];
$display_start_date = $display_result["start_date"];
$display_close_date = $display_result["close_date"];
$display_event_date = $display_result["event_date"];
$display_new_price = $display_result["new_price"];
$display_prereg_price = $display_result["prereg_price"];
$display_other_price = $display_result["other_price"];
$display_door_price = $display_result["door_price"];
$display_dbtext = $display_result["dbtext"];
$display_photo = $display_result["photo"];
echo "
$display_title
\n";
$display_event_date_mdy=date("F d, Y",strtotime ($display_event_date));
$formatted_close_date=date("F d, Y",strtotime ($display_close_date));
if ($todaysdate < $display_close_date) {
echo "
$display_event_title - Saturday,$display_event_date_mdy
\n";
echo "
";
echo "Location: Tera Vista Golf Course - 4332 Tera Vista Drive, Round Rock, TX
\n";
echo "Shotgun Start 8:00 a.m.
\n";
echo "Mulligans Available for $5.00 Each (Limit 4 per team)
\n";
echo "Raffle Tickets $5.00 Each or 6 for $25.00
\n";
echo "Registration Ends: $formatted_close_date
\n";
echo "Registration: $$display_prereg_price per person
\n";
echo "Questions - Contact Bill Holland 512-762-8307 holland13@aol.com
\n";
// echo "
$display_dbtext
\n";
echo "";
}
}
?>