Date Conversion/Handling Help

[Reality15]

Here's the error it's giving me. Line 32 is where the SQL code sits:
Parse error: syntax error, unexpected ')' in /home/pointxtr/public_html/jon/caveman/eventscalendar2.php on line 32

And here's the code in that area of the script:

$sql = "select *, 
date_format(eventdate, '%B %d, %Y') as eventdate_formatted,
if (daysrun > 0, date_fromat(eventdate + interval daysrun day, '%B %d, %Y'), 0) as second_date
from `calendar` WHERE `eventdate` >= '$currentdate' ORDER BY `eventdate` ASC LIMIT $start , 5");
while ($array = mysql_fetch_array($result)) {

$id = $array['id'];
$eventdate = $array['eventdate_formatted'];
if ($array['second_date'] > 0) {
   $second_date = $array['second_date'];
}
    $eventname = $array['eventname'];
    $eventdescription = $array['eventdescription'];

echo "<p align='left'><font face='Arial'><u><b>$eventname<br></b></u><font size='2'><b>$eventdate";
if (!$eventdate){
}
else{
echo " to $second_date";
}
	echo "</b><i></i></font></font><span class='storesmallprint'><font face='Arial' size='2'> - $eventdescription</font></span></p>";

}

Any help would be GREATLY appreciated!

[Kudose]

You have a rogue ) at the end of your SQL, just before the semi-colon.

[Reality15]

Alright, now there's a new error and a new php code.

Error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/eventscalendar2.php on line 33

PHP Code:

$result = mysql_query("select *, 
date_format(eventdate, '%B %d, %Y') as eventdate_formatted,
if (daysrun > 0, date_fromat(eventdate + interval daysrun day, '%B %d, %Y'), 0) as second_date
from `calendar` WHERE `eventdate` >= '$currentdate' ORDER BY `eventdate` ASC LIMIT $start , 5");
while ($array = mysql_fetch_array($result)) {

$id = $array['id'];
$eventdate = $array['eventdate_formatted'];
if ($array['second_date'] > 0) {
   $second_date = $array['second_date'];
}
    $eventname = $array['eventname'];
    $eventdescription = $array['eventdescription'];

echo "<p align='left'><font face='Arial'><u><b>$eventname<br></b></u><font size='2'><b>$eventdate";
if (!$eventdate){
}
else{
echo " to $second_date";
}
	echo "</b><i></i></font></font><span class='storesmallprint'><font face='Arial' size='2'> - $eventdescription</font></span></p>";

}

[Kudose]

Try returning the number of rows your query affects. If it is 0, then there is your problem.