walking through database one record at a time with forms.

From: Date: Wed, 23 Jul 2003 15:37:57 +0000
Subject: walking through database one record at a time with forms.
Groups: php.general 
Request: Send a blank email to php-general+get-156470@lists.php.net to get a copy of this message
I'm tring to create a script for the WEBMASTER to go through a temporary table in a MySQL database, and either accept or reject the data submitted by users. $sql = mysql_query("SELECT * FROM temp_table"); $result = mysql_num_rows($sql); Then with, while($row = mysql_fetch_array($sql)) { ... ... } I create variables and read the first record of the database, Then inside a form the data of the record is displayed along with a ACCEPT and REJECT buttons. How do I have the script stop after displaying the first record and wait until the ACCEPT or REJECT button has been pressed before displaying the next record? Right now the script just continues and displays all the forms in one long page, rather then haveing the execution pause until the ACCEPT/REJECT button beeing pressed.

« previous php.general (#156470) next »