[SOLVED] error in query, need help

[kemper]

$sql = dbquery(
"SELECT ter.*, user_id,user_name FROM f2007_scheduling WHERE club_id='$club_id' ter
LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id
ORDER BY date ASC,time ASC"
);

 

With this query, I am getting:

"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 'ter LEFT JOIN array_users tusr ON ter.sched_user=tusr.user_id ORDER BY date' at line 1"

 

Where are I straying from syntax?

Thanks!

[teng84]

$sql = dbquery(
"SELECT ter.*, user_id,user_name FROM f2007_scheduling ter
LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id
        WHERE club_id='$club_id' ORDER BY date ASC,time ASC"
);

try

[kemper]

Thanks a million!  I should have known that the WHERE statement should go along with the the ORDER.

 

Doh!