Multiple mysql entries with a single $_POST...

[Mr_Mako]

Hi...

I'm sorry if this has been covered before, but I searched for more than an hour to find a solution and was unsuccessful. Admittedly my lack of success may be due to not knowning how to word or phrase my search to get the desired results (due to ignorance of the 'lingo').

I have a question about multiple values in a dropdown menu in a form.

What I have is a form where I am trying to create the ability for users to enter race results data. What I'd like to do is to have the "Finishing Position" drop down menu also enter the finishing points... so the single "Finishing Position" would enter data into "finish_pos" and "points" fields in the database. This is primarily to ensure that no mistakes between finishing position and the points awarded for that position occur.

An example is below:

<form method="POST" action="results.php">
<select size="1" name="finish_pos">
     <option value="1">1</option>
     <option value="2">2</option>
     <option value="3">3</option>
     <option value="4">4</option>
     <option value="5">5</option>
     -ect.-
</select>

As the $_POST stands with the above code, I'd get a single return of 1, or 2, etc. If I placed the points per position in the value, then I'd get a points return only (175, 170, 165, etc.).

So... is it possible for me to do something like the following?

<form method=POST action=results.php>
<select size="1" name="finish_pos">
     <option value="1","175">1</option>
     <option value="2","170">2</option>
     <option value="3","165">3</option>
     <option value="4","160">4</option>
     <option value="5","155">5</option>
     -ect.-
</select>

... and somehow have the PHP code parse the two different results from the single drop down menu into different mysql fields?

Thanks for any help... this may be an incredibly easy thing to do, I just haven't found any examples anywhere that explain it... 🙁

[vivin1]

<form method=POST action=results.php>
<select size="1" name="finish_pos">
<option value="175">1</option>
<option value="170">2</option>
<option value="165">3</option>
<option value="160">4</option>
<option value="155">5</option>
....
.....
</select>

while(list($k,$v) = @each($finish_pos)) {
$sql = "insert into finish_pos values ($k,.......)
execute $sql

$sql = "insert into points values($v,......) "

execute($sql)

}@reset($finish_pos);

where $k stands for Key and $v stands for value.
The first statement wud enter 1,2,3..... into finish pos table
The second statement wud enter 175,170,165..... into points table

read about 'list' and 'each' (www.php.net)

Hope it helps
Viv

[Mr_Mako]

Hi...

This code didn't help me much at all. It did confuse me a lot though... heh.

I've read through the information on "each" and "list" in the php manual as suggested, but I'm still fuzzy on exactly how to make this work (or even if it will).

Maybe a further explaination:

The situation in question has two files associated with it... the "race_results.php" file (where the FORM is and where the user fills out the results), and the "race_submit.php" (where the PHP Code parses the FORM information into the database and gives a successful, or error, result).

Is it possible to combine the $sql statements into a single one, like so:

while(list($k,$v) = @each($finish_pos)) {
     $sql = "INSERT INTO (finish, points) VALUES ('$k', '$v')";
     }
@reset($finish_pos);

or will that work?

At any rate... still struggling with this. 🙁

[Mr_Mako]

Anyone have any ideas? If this is not possible, please let me know... or if there's another way of doing it.