sql:select id,test_name,addtime from `record` where user_id= order by addtime desc,id desc limit 0,8
错误: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 'order by addtime desc,id desc limit 0,8' at line 1
Array
(
[1] => Array
(
[file] => /www/wwwroot/dhsjysy.com/wap/link.php
[line] => 41
[function] => execute_dql2
[class] => SqlHelper
[object] => SqlHelper Object
(
[conn] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[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 'order by addtime desc,id desc limit 0,8' at line 1
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[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 'order by addtime desc,id desc limit 0,8' at line 1
)
)
[field_count] => 12
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.6.50-log
[server_version] => 50650
[stat] => Uptime: 191542 Threads: 1 Questions: 879945 Slow queries: 0 Opens: 112 Flush tables: 1 Open tables: 105 Queries per second avg: 4.594
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 15241
[warning_count] => 0
)
)
[type] => ->
[args] => Array
(
[0] => select id,test_name,addtime from `record` where user_id= order by addtime desc,id desc limit 0,8
)
)
)
