Updating number of rows in tables

[Scott Brown]

Hello,
I want to write a script that will display a table with a number of
rows the user wants. Example, I go to a page and need 30 rows, I press
submit and 30 rows are made.
I was thinking of a FOR EACH statement, but those examples are for
arrays.

Any ideas?

Scott n7seb@softhome. net

[BKDotCom]

like so? or are you even talking about SQL? If not, what's are these
rows?? They've got to come from somewhere. 30 rows of what?

$query = '<snip> LIMIT '.$POST['num_rows_requested'];
$result = mysql_query($query);
$numrows = mysql_num_rows($result); // 'num_rows_requested' ??
echo '<table>';
for ( $i=0; $i<$numrows; $i++ ) {
$row = mysql_fetch_assoc($result);
echo '<TR><TD>'.$row['column'].'</TD></TR>';
}
echo '</table>';
n7***@softhome.net (Scott Brown) wrote in message news:<16**************************@posting.google. com>...

Hello,
I want to write a script that will display a table with a number of
rows the user wants. Example, I go to a page and need 30 rows, I press
submit and 30 rows are made.
I was thinking of a FOR EACH statement, but those examples are for
arrays.

Any ideas?

Scott n7seb@softhome. net