Pagination from a Database colum
<p>I have a database table called "schedule" where there is a date colum. i want to have pagination on top of my result table where initially will display todays date and then i can move forward and backwords.. any ideas </p>

<p>something like this one
<a href="http://www.adkhospital.mv/en/duty/23022013" rel="nofollow">http://www.adkhospital.mv/en/duty/23022013</a></p>

<pre><code>               $duty_roster_sql="SELECT
                        deptment.`name`,
            doctors.depid,
            doctors. `docid`,
                        doctors. `popname`,
            doctors. `fullname`,
                        dutyroster.`time`,  
                        dutyroster.`date`                   
                FROM dutyroster
                        INNER JOIN doctors  ON doctors.`docid`= dutyroster.docid
                        INNER JOIN deptment ON deptment.`deptid`= dutyroster.deptid
                WHERE dutyroster.`date`= '". date('o-m-d')."'  ";
</code></pre>

<p>This is the query used to take dutySchedules record from database where intially displays todays information. i want to have a pagination like</p>

<p>&lt;-back today next-> so when i click next it will display tommrows dutyschedule by querying tommrows information from the database and dispalying it</p>
