Re: [PHP] walking through database one record at a time with forms.

[Marek Kilimajer]

Better would be to make combos (reject, accept) and then submit them all 
at once. Displaying a separate html page for each row is slow and pain 
to work with.

Artoo wrote:

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.




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php