shop with page

[Alkyron]

How to make a shop with pages?

Example :

http://systemgames.no-ip.biz/gunz/index.php?do=cashshop⊂=listallitems&expand=1&page=1

Please need help .

[MentaL]

[sayuta]

Edit the limit?

Like

$page = $_GET['page'];
$limit = '5';
$new = $limit * $page;
$new2 = $new - $limit
$query = mssql_query("SELECT * FROM items WHERE inshop = '1' DESC LIMIT $new2,$new"); 

Somthing like that >_>"..

$page = Get Page id,
$limit = howmuch items per page.
$new2 = starting offset (if $page = 1, starting offset = ((1*5)-5) = 0)
$new = end offset (if $page = 1, starting offset = (1*5) = 5)

Ex. if Page2.
$new2 = ((2*5)-5) = 5
$new = (2*5) = 10

So it will take the items in that gap

[Alkyron]

Wow nice i go edit !

[Alkyron]

Edit the limit?

Like

$page = $_GET['page'];
$limit = '5';
$new = $limit * $page;
$new2 = $new - $limit
$query = mssql_query("SELECT * FROM items WHERE inshop = '1' DESC LIMIT $new2,$new"); 

Somthing like that >_>"..

$page = Get Page id,
$limit = howmuch items per page.
$new2 = starting offset (if $page = 1, starting offset = ((1*5)-5) = 0)
$new = end offset (if $page = 1, starting offset = (1*5) = 5)

Ex. if Page2.
$new2 = ((2*5)-5) = 5
$new = (2*5) = 10

So it will take the items in that gap

Not work . . .

[wesman2232]

cause LIMIT only works in MySQL

[Alkyron]

Help me please

[Wucas]

cause LIMIT only works in MySQL

i like mysql so much more then mssql really <.<

[alfredao]

http://systemgamesonline.com/gunz/do...s/CashShop.rar

[Alkyron]

http://systemgamesonline.com/gunz/do...s/CashShop.rar

Translate please ?