Open: SELECT item.*,cats.longname,cats.pageOrder FROM `shop_items` item
join shop_cats cats on cats.id = item.category
where item.active=1 and cats.active=1 order by cats.pageOrder,item.pageOrder
Shop Items
Shop Items
Checkout
Payment
Confirm
We also have additional inventory on the auction site Gunbroker.com