<% //Create connection to mySQL database //substitute own hostname, username and password $connection = mysql_connect("localhost","root","DaBur9bsh") or die("Could not connect to server"); //Select database //Substitute your own database name $db = mysql_select_db("GOGF", $connection) or die("Couldn't select database"); //Create SQL Statement $sql = "SELECT * FROM EVENTS ORDER BY Sort_Date ASC"; //Execute SQL and get result $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query"); echo " GOGF Events

.

"; while($row = mysql_fetch_array($sql_result)) { $IDV = $row["ID"]; $Sort_DateV = $row["Sort_Date"]; $Display_DateV = $row["Display_Date"]; $Event_DetailsV = $row["Event_Details"]; echo "
    $Display_DateV

    $Event_DetailsV

"; } echo "
 
Copyright 1988, The Grand Old Gospel Fellowship, Inc. All rights reserved.
160 East Main Street, Lansdale, PA 19446-2519. (215) 361-8111
"; //Free resources and close connection mysql_free_result($sql_result); mysql_close($connection); %>