Script 1
|
0) { $f1=$row[“Name”]; ?> 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”; $f8=$row[“event_begin”]; echo ” Event link: ” . $row[“event_link”]. “ “; } 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 “
Please use the Submissions page to submit your event.
“;
}
?>
Script 3
|
0) { $f1=$row[“Name”]; ?> 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”; $f8=$row[“event_begin”]; echo ” Event link: ” . $row[“event_link”]. “ “; } Please use the Submissions page to submit your event. “; } ?> |





