query("SELECT * FROM registrations WHERE code = '$code'");
$result=$sql->fetch_object();
$register_id=$result->registration_id;
?>
$result = $con->query("SELECT r.*, e.event_name, e.event_id, e.cost, e.start_date, e.start_time FROM registrations r, events e WHERE r.event_id=e.event_id AND r.registration_id = $register_id");
$reg = $result->fetch_object();
$event_id=$reg->event_id;
$player_id=$reg->player_id;
$players_firstname=$reg->fname;
$players_lastname=$reg->lname;
$cost=$reg->cost;
$event_name=$reg->event_name;
$event_id=$reg->event_id;
$start_date=$reg->start_date;
$start_time=$reg->start_time;
$reg_type='other';
$ec_name=$reg->ec_name;
$ec_phone=$reg->ec_phone;
$email=$reg->email;
?>
function get_fees($con,$fees_id){
$sql1=$con->query("SELECT * FROM fees WHERE fees_id=$fees_id");
while($m=$sql1->fetch_object()){
$fee=$m->fees_cost;
}
return $fee;
}
function format_time($time){
$new_time=date("g:i a",strtotime($time));
return $new_time;
}
function format_date($date){
$new_date=date("l, n/j", strtotime($date));
return $new_date;
}