Loop Adding

[NZ_Kiwis]

This does not add all my "$group" Drop down menus... I have say 6 of them and I want to set the number to the feild order were "$group" matchs the result id.... does this make sense??

<?php 
if ($action == "save") 
{ 
$result5 = mysql_query ("SELECT * From results_group where comp_run_id = $comp_run_id");
while($row5 = mysql_fetch_array($result5)) {
$group_id = $row5[group_id];

$result = mysql_query ("update results_group set `order` = '$group' where group_id = $group_id") or die("INSERT error0: ".mysql_error()); 

}

?>
<font face="Verdana" size="1">
All done, you can now close this window.
<?php
} else {
?>


<form method="POST" action="grouporder.php?action=save&comp_run_id=<?php echo $comp_run_id; ?>">


<?php

$result = mysql_query ("SELECT group_id COUNT From results_group where comp_run_id = $comp_run_id");
$row = mysql_fetch_array($result);


$result3 = mysql_query ("SELECT * From results_group where comp_run_id = $comp_run_id");
while($row3 = mysql_fetch_array($result3)) {
$group = $row3[group_id];

?>      

<font face="Verdana" size="2"> Group ID: <?php echo $group; ?>
<select size="1" name="<?php echo $group; ?>">
<?php
$i = 1;
$result4 = mysql_query ("SELECT * From results_group where comp_run_id = $comp_run_id");
while($row4 = mysql_fetch_array($result4)) {
?>
 <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php
$i ++;
}
?>
</select>
</p>

<?php
}
?>


<input type="submit" value="Submit data" name="B2" style="border-style: solid; border-width: 1px"></font>

</form>

<?php

}
?>

[halojoy]

hoho
here we go again
I am not a mind-reader - magician with extra sensory perception

so
I have to ask:

1. you expect script to do somthin: your goal
2. you run your script
3. you do not get what you expected
4. you get somthin else
5. HERE IS WHERE you goto www.phpbuilder.com
6. you do tell what you expect script to do
7. YOU DO NOT tell PEOPLE here: WHAT YOU GOT - error or result or a blank screen or what the ..... h''ll

8. Here is where we poor people should do the magic- the long distance mindreading bit

"Excuse me for being a normal person
With plain ordinary and non-magic qualities"
/halojoy 2005 sweden - unforgettable qoutes collection

here is what we know:

This does not add all my "$group" Drop down menus...

I have say 6 of them

I want to set the number to the feild order were "$group" matchs the result id

:p 😉 :p 🙂 :queasy: :glare: :mad: