sql:select * from `goods` where 1 and ( and title like '%168%' ) order by RAND() limit 240,12
错误: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 'and title like '%168%' ) order by RAND() limit 240,12' at line 1
Array
(
[1] => Array
(
[file] => /www/users/HA657934/WEB/cplb.php
[line] => 62
[function] => execute_dql2
[class] => SqlHelper
[object] => SqlHelper Object
(
[conn] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
[client_version] => 50010
[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 'and title like '%168%' ) order by RAND() limit 240,12' 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 'and title like '%168%' ) order by RAND() limit 240,12' at line 1
)
)
[field_count] => 4
[host_info] => 2415.dnstoo.com via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.5.35-log
[server_version] => 50535
[stat] => Uptime: 28715204 Threads: 2 Questions: 6150766533 Slow queries: 55 Opens: 101465 Flush tables: 1 Open tables: 11170 Queries per second avg: 214.198
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 40877903
[warning_count] => 0
)
)
[type] => ->
[args] => Array
(
[0] => select * from `goods` where 1 and ( and title like '%168%' ) order by RAND() limit 240,12
)
)
)
信息检索--168