RE: Code to splite page

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Lawrence,

I'm assuming you are pulling these products from a mysql db. If so you can
use the LIMIT clause. 

$sql = "SELECT * FROM table LIMIT 1, 10"; //where these integers represent
row_count, OFFSET
Read more here http://www.mysql.com/doc/en/SELECT.html

You can substitute a variable for the row_count so that you can page back
and forth via get vars.
$sql = "SELECT * FROM table LIMIT ".$startat.", 10";

If you are pulling from MSSQL then there is no limit functionality and you
have to code the offset yourself. This is a pain and I don't have that chunk
of code on hand right now. Maybe someone else does...

Dan

-----Original Message-----
From: Lawrence [mailto:goodboy@fptnet.com] 
Sent: Thursday, November 27, 2003 8:43 AM
To: php-windows@lists.php.net
Subject:  Code to splite page


I need the code to splite page , I have 50 products , I want splite 10
products per page , if anyone has that , please show me , thank you

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux