Converting Multiheadlines with single quotes [SOLVED]

Posted: Sun Oct 05, 2014 10:21 am

I've been fighting with this error from weeks. Finally the good result. NO MORE ERRORS LIKE THIS!!!

Code:

October 5, 2014, 2:52 pm File: www.bestbuildpc.org/db/mysqli.php - Line: 201


Code: 1064 - Message: 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 '-49680, -49675' at line 1


SQL was: SELECT * FROM `nuke_multiheadlines_news` ORDER BY `news_status` ASC, `news_pubdate` DESC LIMIT -49680, -49675


 remote addr: 66.249.65.128

Here we go with the fix

Original line:

Code:

$sql = "SELECT * FROM ".$prefix."_multiheadlines_news".$string." AND news_status='1' ORDER BY news_pubdate DESC";

Replace with

Code:

$sql = 'SELECT * FROM `' . $prefix . '_multiheadlines_news`' . $string . ' AND `news_status` = 1 ORDER BY `news_pubdate` DESC LIMIT 0, 5';//LIMIT 0, 5

Only registered users can see links on this board! Get registered or login!