a tricky bit of coding!!!

Anon

Well this question maybe a little hard however what i am after to do is to enter fields into a MySQL database however there is a twist.

I am using PHP and javascript to make a on-line sports draw programme. Depending on the number of teams that are there is the number of select boxes that come up with the teams that they can select. A row of what i want to display and insert into the database is team1, team2, ground and time. With naming the select boxes with the same anme in each of the rows how can i then put that into a database putting in as many entry as there is matches.

I don't think that i have explained this very well, however i am thinking and wondering can i use a sort of 'foreach row' type expression and for every row put that as an entry to the database

Thanks a lot in advance

James

fitzbean

yep, you're right.. you have not explained this very well :/

Anon

Let me try again

i have a sports draw program that will hopefully display theteams in a select box where i can select the team that will play another team. The number of boxes that are display depends on the number of teams that there are in the competition. (ie 9 teams = 9 select boxes where a user can select the teams). i am doing that via a "for" statement which i can do fine.

What will happen from there is that the user wil hit submit once they are happy with how everything is entered. Now the question is that if each of those select boxes have the same name in each row. (ie there is team1, team2, ground, and time in each of those rows.) How can i input that into a MySQL database entering a new row of data for each row that is on the webpage(ie one submit push may produce3,4, or 5 rows i the db depending on the number of teams in the comp.)

Hope this explain it a bit better

James

fitzbean

Ok, you have X number of teams. Teams will be playing teams..

Why do you need a select box for each team?

Wouldn't you just need:

A select box for the home team
A select box for the away team
A select box for time of game

Anon

Hi!

You said, you use a for-statemant - so why don't you use varible varibales - I had the same problem with a programm where you can define a variable amount of different questions and you don't have a specific name for those questions the user has to answer. So I just made a for-statement and put on the predefinde varablename the §i-Value and so I got a unique variable-name using variable variables:

Make your form:

for ($i = 1; $i <= $amount; $i++):
echo "<input type=\"input\" name=\"team1$i\" value=\"\" maxlength=\"80\">\n";
echo "<input type=\"input\" name=\"team2$i\" value=\"\" maxlength=\"80\">\n";
echo "<input type=\"input\" name=\"ground$i\" value=\"\" maxlength=\"80\">\n";
echo "<input type=\"input\" name=\"time1$i\" value=\"\" maxlength=\"80\">\n";
endfor;

Working with the variable of the form:

for ($i = 1; $i <= $amount; $i++):
$team1 = 'team1'.$i;
$team2 = 'team2'.$i;
$ground = 'ground'.$i;
$time = 'time'.$i;
// Now to get to the Input of your varibles you defined:
echo ${$team1} . ${$team1} . ${$ground} . ${$time};
endfor;

Hope this code helps.