Home > Backend Development > PHP Tutorial > php异常:You have an error in your SQL syntax; 急

php异常:You have an error in your SQL syntax; 急

WBOY
Release: 2016-06-13 13:39:25
Original
923 people have browsed it

php错误:You have an error in your SQL syntax; 急!!!!!

$sql="select id,title,type_id,time from news limit $offset,$Page_size where type_id=".$type_id; 
echo $sql;
$result=mysql_query($sql) or die($sql."

".mysql_error());; 
while ($row=mysql_fetch_array($result)) 
{  
?> 

 
 
 
 
 
 
 
 
 
 
 
修改   删除
 
 



直接上代码!!!!!错误提示: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 ''0,6' where type_id=21' at line 1 


请问怎么回事啊??????????????????急!!!!!!!!!!!!!!!!!!

------解决方案--------------------
select id,title,type_id,time from news limit $offset,$Page_size where type_id=".$type_id;

修改成

select id,title,type_id,time from news where type_id=".$type_id." ORDER BY ID DESC LIMIT {$offset},{$Page_size}";

看看.
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template