The form is no problem but how do INSERT 10 ROWS with one insert
statement. I figure some kind of loop like I did with the form.
When form is submitted:
$query = "INSERT INTO songs VALUES ('$id',
'$songname','$rating','$video', '$album_id', '$movie')";
$result = mysql_db_query("movies", $query);
if ($result) {
// worked
This is the form:
<form enctype="multipart/form-data" method="post"
action="<?php echo $PHP_SELF ?>">
<?
$i = 1;
while ($i <= $songsinalbum) {
?>
<TR>
<TD align="right">ID: </TD><TD><input type=text name=id value=<? echo
$i; ?> size=3><br></TD>
<TD align="right">Songname: </TD><TD><input type=text name='songname'
size=30><br></TD>
<TD align="right">Rating: </TD><TD><input type=text name='rating'
value='***' size=5 maxsize=5><br></TD>
<TD align="right">Video ID: </TD><TD><input type=text name='video'
size=2 maxsize=3><br></TD>
<TD align="right">Album ID: </TD><TD><input type=text name='album_id'
value=<? echo $id; ?> size=2 maxsize=3><br></TD>
<TD align="right">Movie ID: </TD><TD><input type=text name='movie'
size=2 maxsize=3><br></TD></TR>
<?
$i++;
};
?>
<input type="submit" name="submit" value="Upload">
</form>
</TABLE>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
