Code: Select all
select
tblCalendars.calName,
tblEvents.eventName,
date(tblEvents.eventBegins),
time(tblEvents.eventBegins),
time(tblEvents.eventEnds),
period_diff(tblEvents.eventEnds, tblEvents.eventBegins)
from tblEvents, tblCalendars where tblCalendars.calId = tblEvents.calId and date(tblEvents.eventBegins) = curdate();
Here's the PHP:
Code: Select all
$thesqlstring = "select
tblCalendars.calName,
tblEvents.eventName,
date(tblEvents.eventBegins),
time(tblEvents.eventBegins),
time(tblEvents.eventEnds),
period_diff(tblEvents.eventEnds, tblEvents.eventBegins)
from tblEvents, tblCalendars where tblCalendars.calId = tblEvents.calId and date(tblEvents.eventBegins) = curdate()";
print $thesqlstring;
$result = mysql_query($thesqlstring);
--You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1--
Why is " showing up as an error? Even if I use a ' to set the sql statement it throws the same error. I've been looking at this for far too long and need an extra set of eyes for help.