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]