LifeType 中文開發論壇

支援 => 使用與操作 => 主題作者是: colin 於 六月 21, 2005, 03:04:19 下午



主題: MySQL Error
作者: colin六月 21, 2005, 03:04:19 下午
程式碼:
21-06-2005 08:12:51 ERROR - The following query =
SELECT u.id AS id, u.user AS user, u.password AS password, u.email AS email,
                                 u.about AS about, u.full_name AS full_name, u.properties AS properties,
                                 u.resource_picture_id AS resource_picture_id,
                                 IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                                 u.status AS status
                          FROM plog_users u LEFT JOIN plog_users_permissions p ON u.id = p.user_id
                          WHERE u.id =
generated the following error message =
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 7


/tmp/sql_error.log

的报错


主題: MySQL Error
作者: markwu六月 23, 2005, 11:06:09 上午
你要問什麼?

Mark