Suspend PHP While Loop

[yrushalayyim]

Hello:

 

I am using PHP with MYSQL to display records in various tables in my SQL database.  I use a while loop to display the records, but if there are too many records in a table the records spill past the bottom of my web page.

 

I want to display the records one at a time, suspending the display until the viewer clicks on one of two clickable text items: "Click For Next Record" or "Exit".  I don't want to use pause() or wait(), because they require a time limit.

 

How do I suspend the display until one of the text items is selected?  Is there a "do until" php statement?

 

Thanks,

 

Stuart Braun

[email protected]

[BlueSkyIS]

use a LIMIT clause in your SQL to limit the number of records returned. "Next Record" will execute a SQL query with a LIMIT clause to pull up and display the next batch of records.