[tommyc325]

im getting a error in one of my pages where im trying to set up one of those page navigation ( Next Last Page 1,2,3,4,5,6,7) so anyways i figured out that it has to do with these 2 lines arguing for some reason.


$query_news = "SELECT id, headline, content, date_format(date, '%c-%d-%y') as 'date_f' FROM news WHERE date <= $today2 ORDER by date DESC LIMIT 10, $spitrecords";
$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);

the weird thing is if i take out LIMIT 10, $spitrecords in the main query it works fine but it's very important that i keep that line in there.

Any Takers.

Thanks guys

Tom

[NeverMind]

you can't have 2 LIMITs in your query!
the first one is in $query_news and the secon one in $query_limit_news! so if you print $query_limit_news you will probably see something like this:

Code:

SELECT id, headline, content, date_format(date, '%c-%d-%y') as 'date_f' FROM news WHERE date <= $today2 ORDER by date DESC LIMIT 10, $spitrecords LIMIT %d, %d

which is wrong.

[tommyc325]

thanks again nevermind but what would be correct then.

[NeverMind]

you said it yourself
remove one of the LIMITs and it will work..

[tommyc325]

Hey nevermind that worked but for some reason every time i go to the next page i`m getting the same records showing up

http://www.alteredimage.com/testsite/newsarchives.php

not sure why though.

Any suggestions.