shop with page

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 .

Edit the limit?

Like

PHP Code:

---

$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

Wow nice i go edit !

Quote:

---

Originally Posted by sayuta

Edit the limit?

Like

PHP Code:

---

$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 . . .

cause LIMIT only works in MySQL

Help me please

Quote:

---

Originally Posted by wesman2232

cause LIMIT only works in MySQL

---

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

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

Quote:

---

Originally Posted by alfredao

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

---

Translate please ?