Race Events

[insert_php]

if ($_POST[‘submitted’] == “true”) {
$result = $_POST[‘field’];
$result_explode = explode(‘|’, $result);

require_once( ABSPATH . WPINC . ‘/mysqli_connect.php’ );

// Make the query:

$q = “SELECT * from tb_program where date = ‘$result_explode[0]'”;

$r = @mysqli_query ($dbc, $q); // Run the query

//Count the number of records:

$num =@mysqli_num_rows($r);

if ($num>0) { // If it ran OK, display the records.

// Table header.

echo “

“;

echo ‘

‘;

// Fetch and print all the records

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

echo ‘

‘;
} // End of WHILE loop

echo ‘

‘; // Close the table.

//This is the end of all the loops and Else Ifs additional Output tables should be above this.

mysqli_free_result($r); // Free up the resources.

} else {

//Public message:
echo “

“;
echo ‘

No Swim Club

‘;

// Debug messgae:

// echo ‘

‘ . mysqli_error($dbc) . ‘

Query: ‘ . $q . ‘

‘;

}

mysqli_close($dbc); // Close the database connection.

} else {

//Public message:

echo ‘

You have access this page incorrectly

‘;

}

[/insert_php]