造型精靈

[code]Script: /Discuz/virtualimage.php

SQL: SELECT u.* , m.username,i.imagename,i.endurance as dates FROM cdb_images_user u ,cdb_images_data i LEFT JOIN cdb_members m ON m.uid = u.imagefrom WHERE u.userid = '1' AND u.dafaultuse = '1' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata
Error: Unknown column 'u.imagefrom' in 'on clause'
Errno.: 1054

Similar error report has beed dispatched to administrator before.[/code]

[code]SQL: SELECT u.* , m.username,i.imagename,i.endurance as dates,i.cost,i.stock,i.open FROM cdb_images_user u ,cdb_images_data i,cdb_members m WHERE u.dafaultuse = '8' AND m.uid = u.userid AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata DESC LIMIT -1, 10
Error: 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 '-1, 10' at line 1
Errno.: 1064
[/code]

呢兩句野講咩??

[[i] 本帖最後由 Jade 於 2007-5-8 23:17 編輯 [/i]]