Discuz! info: MySQL Query Error
User: 小新仔
Time: 2006-11-13 9:57pm
Script: /game_mine.php
SQL: SELECT c.gameclass as gc,g.id as id, g.hteam as hteam, g.vteam as vteam, g.gamedate as gamedate, g.gametime as gametime, g.hteamrate as hteamrate, g.vteamrate as vteamrate, g.equalrate as equalrate, u.game1 as game1, u.game2 as game2, u.duzhu as duzhu FROM cdb_game_class c JOIN cdb_game_game g JOIN cdb_game_dudan u ON c.id=g.gameclass and g.id=u.gameid WHERE g.ending='0' AND u.username='小新仔' ORDER BY g.gamedate DESC, g.gametime DESC
Error: You have an error in your SQL syntax near 'ON c.id=g.gameclass and g.id=u.gameid WHERE g.ending='0' AND u.username='小新仔'' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before.
到底怎么解决阿 |