TalkPHP - View Single Post

Orc · 02-08-2008, 12:14 AM

No, though I got 1 and Next up, and I put I got prev working, though it's stuck on page 1 so it doesnt show prev, but I still cannot get the query right. :[ I have two queries, one of them is count and the other is the regular query which displays all the news. If I try to put a limit with that using $max or $num ( $page - $max * $max ) then I would get an error, I looked at the error using mysql_error(), and nothing is there. so yeah, it's not working :P

Code:

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 '''' at line 1

I tried both methods:

Code:

quotes . foo,bar . quotes

and

Code:

noquotes foo,bar noquotes

Still doesnt show up..

02-08-2008, 12:14 AM	#18 (permalink)
Orc The Prestige Join Date: Dec 2007 Posts: 1,044 Thanks: 193	No, though I got 1 and Next up, and I put I got prev working, though it's stuck on page 1 so it doesnt show prev, but I still cannot get the query right. :[ I have two queries, one of them is count and the other is the regular query which displays all the news. If I try to put a limit with that using $max or $num ( $page - $max * $max ) then I would get an error, I looked at the error using mysql_error(), and nothing is there. so yeah, it's not working :P Code: 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 '''' at line 1 I tried both methods: Code: quotes . foo,bar . quotes and Code: noquotes foo,bar noquotes Still doesnt show up.. __________________ VillageIdiot can have my babbies ;d