Insert more than one row into MySQL

[mjhaston]

I have a form that works great to submit the score from one Pop Warner football game at a time. Now I'd like to reuse and modify the code so that I can submit an entire association's scores at once. I'd like one person to submit up to 25 scores in one form and have it create 25 rows in my database.

I can show you the code that works now and what I'm working on. I only have this working because I have ezSQL and Dadabik, two PHP/MySQL tools that make morons like me dangerous!!

People have suggested me trying to use arrays and loops to perform this. If it were on an AS400 and I was working with RPGIV ... no problem.

If you can help I'd appreciate it. If you can write the script for a few bucks I may even just pay for a form/script if that's what it takes. I have a feeling this is out of my league!

[TheIceman5]

its not out of league, its a beginners script, very basic. you need a loop, yes, you dont really need arrays
just name the 25 different boxes different things like scrore1, score2 etc...
in php file a simple way of doing it would be

for($count;$count<25)$count++)

insert into database $_POST["score".$count."" ] if score$count !=""

end loop

[mjhaston]

do i have to declare 'count' somewhere? it doesn't like the beginning of the loop. craps out on that line of code.

Here's what works now. These are frields entered once in the database. I'm thinking now that I might modify this:

<?php

include_once "ez_sql.php";

$result = mysql_query("INSERT INTO weeklyscores (assoc_name, league_name, submitted_by, email, week, game_date) 
VALUES ('$assoc_name', '$league_name', '$submitted_by', '$email', '$week', '$game_date')"); 

This code didn't work. If I could just get this field working I can apply it to the others:

for($count;$count<5)$count++) 
{
insert into weeklyscores $_POST["score_a_".$count."" ] if score_a_$count !="" ;
}