Re: MYSQL error

"DOH!" thanks alot. would you believe i wasted an hour trying to find that one ? clayton btw - that was fast ! ""Carroll Barrett"" <cbarrett@inalt.com> wrote in message news:07e501bfdbc4$9f3e5ac0$170117ac@cbtemp.inalt.com... > Clayton, > > From just a quick glance, remove the comma at the end of your > select fields list (after ts.TimeSpent). I am not familiar with > MySQL's join syntax. > > Regards, > Carroll Barrett > > -----Original Message----- > From: clayton collie <ccollie@cau.edu> > To: php-db@lists.php.net <php-db@lists.php.net> > Date: Wednesday, June 21, 2000 4:12 PM > Subject: [PHP-DB] MYSQL error > > > >can someone tell me whats wrong with this query ? > >im using MYSQL 3.22.22, so i cant do a condition on an inner > join (hence the > >left join). MySQL complains about a syntax error. > > > >select u.UserId, u.LastName, u.FirstName, > > ts.TestName, ts.Score, ts.StartDate, ts.StartTime, > ts.TimeSpent, > >from users u, test_scores ts > >left join users on (u.UserId = ts.UserId) > > > > > >clayton > >_____________________________________ > >"Fried Ice-Cream is a reality !" - George Clinton > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >