Pls i need your help concerning a program that on PHP code using Mysql and Apache as the webserver. i need to select some record from the database which will give about 500 records at a time i need to braek it smaller unit like 40 records at a time on clicking on the next like it should give me the next 40 records still using thesame page and on clicking on the previouis button it should give me the previous 40 records on thesame page pls how can i go about that
i use this query in my PHP coding
$query="select * from tabinfo limit $x,40";
where $x is the starting point where it will display the next 40 records
thxs!