[insert_php]
//Set the variables
// Get the date (set it for 2 days prior)
$today = date (‘Y-m-d h:m:s’, mktime(0, 0, 0, date(“m”) , date(“d”), date(“Y”)));
$compareToday = strtotime($today);
$count = 0;

// Set The Databases

$hostname1 = “localhost”;
$username1 = “bclawcom_euser”;
$password1 = “bc69records”;
$database1 = “bclawcom_events”;

mysql_connect(localhost,$username1,$password1);
@mysql_select_db($database1) or die( “Unable to select database”);
//Define the query
$query = “SELECT eventdate, location, website, notes \n
FROM concerts \n
WHERE eventdate >= now()\n
order by 1”;
$result=mysql_query($query);

$num=mysql_numrows($result);

$format=’F j, Y’;
$i=0;
while ($i < $num) { //$f1=mysql_result($result,$i,"eventdate"); $tempDate=mysql_result($result,$i,"eventdate"); $newDate = date("m/d/Y", strtotime($tempDate)); $f1=$newDate; $f2=mysql_result($result,$i,"location"); $f3=mysql_result($result,$i,"website"); $f4=mysql_result($result,$i,"notes"); echo"

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;
echo”

“;

$i++;
}
[/insert_php]

Date Location Website Details
$f1 $f2 $f3 $f4