New Tournament info

| 0

Script 1

0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {

$f1=$row[“Name”];
$f2=$row[“Address”];
$f3=$row[“City”];
}
} else {}

?>

Tournaments at this facility:

“;

$sql=”SELECT event_title, event_begin, event_end, event_link FROM `wp_my_calendar` WHERE `event_street` = ‘$f2’ AND `event_city` = ‘$f3’ ORDER BY event_begin”;
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo “” . $row[“event_title”]. ““, ““;

$f8=$row[“event_begin”];
$f8 = date(“D-M-d-Y”, strtotime($f8));
echo ” Starts – “, $f8, “
“;

echo ” Event link: ” . $row[“event_link”]. “

“;

}
} else {echo “

There are no adult bowling tournaments listed for this facility at this time.
Please use the Submissions page to submit your event.

“;
}

?>

Script 2

Tournaments at this facility:

“;

$sql=”SELECT event_title, event_begin, event_end, event_link FROM `wp_my_calendar` WHERE `event_street` = ‘$f2’ AND `event_city` = ‘$f3’ ORDER BY event_begin”;
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo “” . $row[“event_title”]. ““, ““;

$f8=$row[“event_begin”];
$f8 = date(“D-M-d-Y”, strtotime($f8));
echo “
Starts: “, $f8, “
“;

echo ” Event link: ” . $row[“event_link”]. “

“;

}
} else {echo “

There are no adult bowling tournaments listed for this facility at this time.
Please use the Submissions page to submit your event.

“;
}

?>

Script 3

0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {

$f1=$row[“Name”];
$f2=$row[“Address”];
$f3=$row[“City”];
}
} else {}

?>
“, $f2, “
“, $f3 ?>

Tournaments at this facility:

“;

$sql=”SELECT event_title, event_begin, event_end, event_link FROM `wp_my_calendar` WHERE `event_street` = ‘$f2’ AND `event_city` = ‘$f3’ ORDER BY event_begin”;
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo “” . $row[“event_title”]. ““, ““;

$f8=$row[“event_begin”];
$f8 = date(“D-M-d-Y”, strtotime($f8));
echo ” Starts – “, $f8, “
“;

echo ” Event link: ” . $row[“event_link”]. “

“;

}
} else {echo “

There are no adult bowling tournaments listed for this facility at this time.
Please use the Submissions page to submit your event.

“;
}
?>