for-if loop. Why does this not work????
Posted: Tue Sep 05, 2006 7:44 pm
This is part of a code for a registration page, and both adults and children, but has different codes for both of them. When I run this code with 2 adults and 2 children it only rarely inserts all four, most of the time its three and sometimes it's only one or two, and I can't figure out why.
Thanks
Code: Select all
for ($i=1;$i<=$totalPeople;$i++) {
if ($i<=$numAdults) {
$adult_child = "adult";
$fullName = $HTTP_POST_VARS['adultName' . $i];
$parent_guardian = "";
$phNum = $HTTP_POST_VARS['adultPhNum' . $i];
$email = $HTTP_POST_VARS['adultEmail' . $i];
$address = $HTTP_POST_VARS['adultAddress' . $i];
$city = $HTTP_POST_VARS['adultCity' . $i];
$state = $HTTP_POST_VARS['adultState' . $i];
$zip = $HTTP_POST_VARS['adultZip' . $i];
$shirtSize = $HTTP_POST_VARS['adultShirtSize' . $i];
$IdNum;
for ($y=0; $y<30; $y++) {
$IdNum .= chr(mt_rand(35, 126));
}
$sql2 = sprintf("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($IdNum, "text"),
GetSQLValueString($payerIdNum, "int"),
GetSQLValueString($adult_child, "text"),
GetSQLValueString($fullName, "text"),
GetSQLValueString($parent_guardian, "text"),
GetSQLValueString($phNum, "text"),
GetSQLValueString($email, "text"),
GetSQLValueString($address, "text"),
GetSQLValueString($city, "text"),
GetSQLValueString($state, "text"),
GetSQLValueString($zip, "int"),
GetSQLValueString($shirtSize, "text"));
mysql_query($sql2, $RR);
} else {
$x = $i - $numAdults;
$adult_child = "child";
$fullName = $HTTP_POST_VARS['childName' . $x];
$parent_guardian = $HTTP_POST_VARS['childParent-guardian' . $x];
$phNum = $HTTP_POST_VARS['childPhNum' . $x];
$email = $HTTP_POST_VARS['childEmail' . $x];
$address = $HTTP_POST_VARS['childAddress' . $x];
$city = $HTTP_POST_VARS['childCity' . $x];
$state = $HTTP_POST_VARS['childState' . $x];
$zip = $HTTP_POST_VARS['childZip' . $x];
$shirtSize = $HTTP_POST_VARS['childShirtSize' . $x];
$IdNum;
for ($z=0; $z<30; $z++) {
$IdNum .= chr(mt_rand(35, 126));
}
$sql2 = sprintf("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($IdNum, "text"),
GetSQLValueString($payerIdNum, "int"),
GetSQLValueString($adult_child, "text"),
GetSQLValueString($fullName, "text"),
GetSQLValueString($parent_guardian, "text"),
GetSQLValueString($phNum, "text"),
GetSQLValueString($email, "text"),
GetSQLValueString($address, "text"),
GetSQLValueString($city, "text"),
GetSQLValueString($state, "text"),
GetSQLValueString($zip, "int"),
GetSQLValueString($shirtSize, "text"));
mysql_query($sql2, $RR);
}
$IdNum = "";
}Thanks