select query, join question

[Link14716]

Wouldn't this work?
[sql]// SELECT UPCOMING EVENTS FROM DATABASE
$msc_events = $DB_site->query("SELECT*
FROM calander_events
LEFT JOIN msc_events ON (msc_events.eventid = calendar_events.eventid)
WHERE (UNIX_TIMESTAMP('$msc_date_extended')) <= UNIX_TIMESTAMP(calendar_events.eventdate)
AND UNIX_TIMESTAMP(calendar_events.eventdate) <= (UNIX_TIMESTAMP('$msc_month_extended'))
AND calendar_events.public = 1
ORDER BY calendar_events.eventdate ASC
LIMIT 6
");[/sql]