Message-ID: <4DFBD8A0.9000503@softpro.bz>
Date: Sat, 18 Jun 2011 01:43:44 +0300
From: hatem gamal elzanaty <hatem@softpro.bz>
User-Agent: Thunderbird 2.0.0.24 (X11/20101213)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: pagination problem in postgresql need help
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

hi,
please see this code

select aiah_number.aiah_number_id, aiah_number.aiah_number, 
lock.lock_status, rank.rank_value, approve.approve_status, lock.view 
from aiah_number inner join lock on aiah_number.locked = lock.lock_id 
inner join rank on aiah_number.rank = rank.rank_id inner join approve on 
aiah_number.approve = approve.approve_id order by rank_value desc limit 
1 offset 0;

and this code

select aiah_number.aiah_number_id, aiah_number.aiah_number, 
lock.lock_status, rank.rank_value, approve.approve_status, lock.view 
from aiah_number inner join lock on aiah_number.locked = lock.lock_id 
inner join rank on aiah_number.rank = rank.rank_id inner join approve on 
aiah_number.approve = approve.approve_id order by rank_value desc limit 
1 offset 1;

suppose i have 200 hundred record and i want to display records in pages 
one record per page i'm facing a problem even if i'm running the script 
through phppgadmin it's only display the first record in the page only 
no more no less in the php code it display record 1 and records byound 
180 and so on

can you help in that issue ?

thanks in advance