Error displaying results?!?

[webnoob]

Ive decided that the code i posted to be wrong was right after all (Its amazing what sleep can do )

There is a problem though, heres the code again:

$StartRow = ($PageNum - 1) * 4;
$EndRow    = ($PageNum * 4) - 1; 

which works with:

.    ' LIMIT ' . $StartRow .', ' . $EndRow 

Now this in theory works fine and on
page 1 it should display 0, 3
Page 2 = 4,7 and so on.....

However instead of starting from row 4 on page 2 its seems to start from 0 and displays 7 results and then in the next window 7 again

Heres the link (goto php, then sessions) Check it out



Anyone got any ideas

[HardCoded]

Yeah, it's wrong. The second number in the limit clause is a range, not the last row.

[webnoob]

ahhh, right so the range on page 2 is 7 so it will display 7. Ok then how would i set a marker at lets says row 5, 10, 15 and so on.. (Can it be done :'( )

[webnoob]

YAY!!!!!!!!!!!!!!!!!!!!!!!!!!!! the info you gave me alowed me to change my code a little and now it works (well more or less )

Its still displaying the last entry on each page as the first entry on the next page but im sure ill get round that.



Thanks ever so much

[webnoob]

Sorted :d