Ok guys... can someone else please lend me their eyes.
This keeps telling me that there is a parse error on the very last line of the file and I can't figure out what the hell is wrong.
I use a nifty little class to do my database stuff, which is why you won't see all the connection and query crap.
I know the code is messy... i'm kind of rushing.
Anywho... please take a look:
<?php
// Include the mysql database access class
include_once "ez_sql.php";
?>
<html>
<head>
<title>
5th Street Band Home
</title>
<meta name="generator" content="BBEdit 6.5.3">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body bgcolor="#000000" topmargin="0" leftmargin="0" marginheight="0">
<table width="702" align="center" border="0" cellspacing="0" cellpadding="0" bgcolor="#D6D6D6">
<tr bgcolor="#D6D6D6">
<td width="3" bgcolor="#FFFFFF">
<img src="white.gif" width="3" height="1" border="0">
</td>
<td width="696" align="center" valign="top">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version%3D6,0,0,0" width="696" height="167" id="skyline">
<param name="movie" value="skyline.swf?where=media">
<param name="quality" value="high">
<param name="scale" value="exactfit">
<param name="salign" value="T">
<param name="bgcolor" value="#FFFFFF">
<embed src="skyline.swf?where=media" quality="high" scale="exactfit" salign="T" bgcolor="#FFFFFF" width="696" height="167" name="skyline" align="top" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">
</embed>
</object>
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D6D6D6" valign="top">
<td width="20" valign="top"> <img src="spacer.gif" width="20" height="1" border="0"></td>
<td width="329" align="left" valign="top">
<img src="spacer.gif" width="329" height="20" align="top">
<table width="329" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF">
<tr>
<td width="329">
<table width="327" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td>
<span class="homeheader">Upcoming Shows</span>
</td></tr>
<?php
// retrieve all the gigs records and Venue Name and ID
$gigs = $db->get_results('SELECT v.name, date_format(g.gigdate,"%c/%e") as gigdate, time_format(g.gigstart,"%l:%i %p") as gigstart, g.comments,v.website,v.directions,g.over_cover,g.under_cover,g.Opener,g.Headliner FROM gigs g, venues v WHERE g.v_id = v.venueid AND g.gigdate>=curdate() ORDER by g.gigdate, g.gigstart');
//debug if you want to debug
//$db->debug();
//checks to see if the query returned any info
if($EZSQL_ERROR)
{
//dumps the errors out to the browser
$db->vardump($EZSQL_ERROR);
echo "Database Error";
}
else
{
if(!$gigs)
{
?>
<tr><td>
<img src="spacer.gif" width="327" height="10">
<img src="spacer.gif" width="5" height="1">
<span class="body">
No gigs are currently scheduled. Please check back <em>soon.</em></span>
<img src="spacer.gif" width="5" height="1">
<img src="spacer.gif" width="327" height="10">
</td>
</tr>
<?php
}
else
{
$white=0;
foreach($gigs as $gig)
{
if($white==0)
{
$bgcolor="#D6D6D6";
$spacercolor="'spacer.gif'";
}
else
{
$bgcolor="#FFFFFF";
$spacercolor="'white.gif'";
}
echo "<tr bgcolor=$bgcolor><td>";
echo "<img src=$spacercolor width='327' height='10'> <img src=$spacercolor width='5' height='1'>";
//Here goes the gig content
echo "<table width='317'><tr>";
echo "<td width='100' align='left'>";
echo "<span class='body'>";
echo "$gig->gigdate <img src=$spacercolor width='5' height='1'> @ <img src=$spacercolor width='5' height='1'> $gig->gigstart </td>";
echo "<td>";
if($gig->website)
{
echo "<a href='$gig->website' target='_blank'>$gig->name</a></td>";
}
else
{
echo "$gig->name</td>";
}
echo "<td align='right'>";
if($gig->directions)
{
echo "<a href='$gig->directions' target='_blank'>Directions</a></td></tr>";
}
else
{
echo "Directions Coming</td></tr></span>";
}
echo "</table>";
echo "<img src=$spacercolor width='5' height='1'> <img src=$spacercolor width='327' height='10'>";
}
}
?>
</td></tr>
</table>
</td>
</tr>
</table>
<img src="spacer.gif" width="329" height="5">
</td>
<td width="20"><img src="spacer.gif" width="20" height="1" border="0"></td>
<td width="307" valign="top">
<img src="spacer.gif" width="307" height="20">
<!--Right side image goes here-->
<img src="spacer.gif" width="307" height="10">
</td>
<td width="20"><img src="spacer.gif" width="20" height="1" border="0"></td>
</tr>
</table>
<img src="white.gif" width="656" height="2"><br>
<img src="spacer.gif" width="696" height="5"><br>
<div align="left" id="footer"><img src="spacer.gif" width="16" height="1">
Copyright © the 5th Street Band
</div> <br>
<img src="spacer.gif" width="696" height="25">
</td>
<td width="3" bgcolor="#FFFFFF">
<img src="white.gif" width="3" height="1" border="0" align="middle">
</td>
</tr>
</table>
</body>
</html>
