// Connect to database include $_SERVER['DOCUMENT_ROOT']. '/scripts/dbconnect.php'; mysql_select_db("uksmg_e107") or die("Cannot select database"); // Get all the data from the spots table //$result = mysql_query("SELECT * FROM spots WHERE band=6 ORDER BY utc DESC") $result = mysql_query("SELECT * FROM `spots` WHERE DATE(utc) = DATE(NOW()) AND spots.spotter_prefix Like \"2%\" AND spots.band=6 OR DATE(utc) = DATE(NOW()) AND spots.spotter_prefix Like \"M%\" AND spots.band=6 OR DATE(utc) = DATE(NOW()) AND spots.spotter_prefix Like \"G%\" AND spots.band=6 ORDER BY id DESC LIMIT 0 , 30") or die(mysql_error()); ?> Today on Six"; echo ""; echo ""; // keeps getting the next row until there are no more to get while($row = mysql_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 "