Looping insert from dynamic selects

Svoboda

I'm still a virtual newbie when it comes to PHP, but I have been able to teach myself a thing or two from reading tutorials, etc. Anyhow, I'm now stuck and not sure how to create a looped insert.

Below is my code to dynamically create 11 selects named 1 through 11. These selects are rankings for 11 teams and what I'm wanting to happen is the user will rank the 11 teams and then submit the votes.

Since my votes table stores each rank as an individual record, I'm not sure how I should loop through to store each select as it's own record. Any ideas or helpful pushes would be great!

<?

$place = 1;
while ($place < 12) {

$query = "select * from team";
$result = mysql_query($query);

echo ("<tr><td>$place.</td>");
echo ("<td><select name=\"$place\">");

while($row = @mysql_fetch_array($result, MYSQL_ASSOC))
{

echo ("<option value=\"{$row['teamid']}\">{$row['teamname']}</option>");

}

echo ("</select></td><tr />");

$place++;

}

?>

cyberlew15

This needs recognition of processes involved and their implementations on the web
- so u need to check if that data has been submitted from an html form
- if so show resulting screen
- if not show default screen
you can use

if(!isset($_POST['formfieldname'])){
// default
}
if(isset($_POST['formfieldname'])){
// now do something based on data
}

Svoboda

Right, but that doesn't deal with the fact that twelve records need to be inserted from that code. That's where I'm stuck.

Weedpacket

Since you can write a loop to generate <select> elements, you can also write a loop to generate database Insert statements.....

Svoboda

Weedpacket wrote:
Since you can write a loop to generate <select> elements, you can also write a loop to generate database Insert statements.....

Yes, again... that's easy. However, the <select> elements have unique names.

Weedpacket

And those names are....? 1 to 11 you said?

$select_names = array(1, 2, ..., 11);

foreach($select_names as $select)
{
    // as cyberlew15 noted, check that this exists.
    $select_value = $_POST[$select];
   //...insert INSERT statement here.
}

Svoboda

Now that makes some sense to me. Let me go take that and see if I can write something. Excuse my noobness.

cyberlew15

Hey great work weedpacket on explaining sum stuff to this guy

now there are a few things tho

1st and foremost dont give html elements id's or names starting with or exclusively numbers as it's not w3c and this could lead to problems in the future.

2nd you would probably have two arrays, i suggest having a common mysql connect and query but change the table queried based upon the select objects values, you would do this by changing a variable with

$tblname = "default_table_queried";
if(isset($POST['selname'])){
    $tblname = $_POST['selname'];
}
[CODE]

Then just set the mysql table specified in your mysql query as a variable rather than a string, bobs your uncle, fanny's ur aunt job done!

Anythig I missed?