How do you create a next and previous button using php and oracle as your database? For example, I have 100 records and I only want to show 30 records at a time. I really have no clue on how to do it. I know it can be done using php and mysql but our project requires us to use oracle as database.
first to limit the records to show only a certain 30 records, you can add LIMIT(start, number of records) at the end of your SQL query
then, you have to make a GET paramater (such as page.php?start=30) and use “your query … LIMIT (” . $_GET["start"] . “,30″
good luck!