// Set Timezone to UTC date_default_timezone_set('UTC'); // Connect to database include $_SERVER['DOCUMENT_ROOT']. '/scripts/dbconnect2.php'; if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit(); } // Get all the data from the spots table //$result = mysql_query("SELECT * FROM spots WHERE band=6 ORDER BY utc DESC") $result = mysqli_query($con,"SELECT * FROM spots WHERE DATE(utc) = DATE(NOW()) AND spots.band=6 ORDER BY spots.id DESC LIMIT 0 , 30"); ?> Today on Six"; echo ""; echo ""; // keeps getting the next row until there are no more to get while($row = mysqli_fetch_array( $result )) { // Print out the contents of each row into a table echo ""; } echo "

DX	Loc	Time	QRG	Comment	Spotter
"; echo htmlentities($row['dxcall'], ENT_QUOTES); echo "	"; echo strtoupper(htmlentities($row['dxlocator'], ENT_QUOTES)); echo "	"; echo date("H:i", strtotime($row["utc"])); echo "	"; echo number_format($row['freq'], 1, '.', ''); echo "	"; echo htmlentities($row['comment'], ENT_QUOTES); echo "	"; echo htmlentities($row['call'], ENT_QUOTES); echo "