vus520哥哥...用了你的自动发布文章程序出现这种问题!~~~

lzkz168

<?php
/*
Page: /new.php?no=20&order=rand
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 'rand  limit 20' at line 1 <br />Error sql: <font color='red'>SELECT id FROM `dede_archives` where arcrank ='-1'   order by id rand  limit 20 ;</font>
*/
?>
<?php
/*
Page: /new.php?no=20&order=rand
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 'rand  limit 20' at line 1 <br />Error sql: <font color='red'>SELECT id FROM `dede_archives` where arcrank ='-1'   order by id rand  limit 20 ;</font>
*/
?>
<?php
/*
Page: /new.php?no=20&order=rand
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 'rand  limit 20' at line 1 <br />Error sql: <font color='red'>SELECT id FROM `dede_archives` where arcrank ='-1'   order by id rand  limit 20 ;</font>
*/
?>
<?php
/*
Page: /new.php?no=50&order=rand
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 'rand  limit 50' at line 1 <br />Error sql: <font color='red'>SELECT id FROM `dede_archives` where arcrank ='-1'   order by id rand  limit 50 ;</font>
*/
?>

俺不懂SQL...vus520哥哥能说下是什么原因吗???

ghostscat

语法错误

lzkz168

语法错误
ghostscat 发表于 2009-5-11 11:40

大哥...能告诉我解决办法吗?

vus520

这是Mysql的语法错误,需要把SQL语句的rand改成rand()