ممرض محترف
12-02-2006, 10:55 AM
المشكله
Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "32%" OR u.downloads LIKE "%32%" OR u.downloads LIKE "%32" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'
mysql error number: 1054
الحل
ازرع الامر التالي
ALTER TABLE `user` ADD `downloads` **** NOT NULL;
Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "32%" OR u.downloads LIKE "%32%" OR u.downloads LIKE "%32" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'
mysql error number: 1054
الحل
ازرع الامر التالي
ALTER TABLE `user` ADD `downloads` **** NOT NULL;