Page 1 of 1

Multiple MySQL Queries

Posted: Thu Jul 20, 2006 11:26 am
by Clukey
I am trying to loop through sets data and insert a record for each set, but when I do it takes a long time and then it says it lost the connection with the database. I am using this (or a slight variation of this) twice, then also sending another query outside of a loop. How can this be done? Thanks

Posted: Thu Jul 20, 2006 11:28 am
by RobertGonzalez
Post some code so we can see what is going on.

Posted: Thu Jul 20, 2006 11:28 am
by daedalus__
/agree

Posted: Thu Jul 20, 2006 11:32 am
by Clukey
Here's the connection:

Code: Select all

$hostname_RR = "localhost";
$database_RR = "db";
$username_RR = "username";
$password_RR = "password";
$RR = mysql_pconnect($hostname_RR, $username_RR, $password_RR) or die(mysql_error());


Here's the queries:

Code: Select all

if ($resultMsg == "APPROVED") {
	mysql_select_db ("db");
	$query = mysql_query ("SELECT * FROM db");
	$row_RR = mysql_fetch_assoc($query);
	mysql_query ("SELECT * FROM db");
	mysql_query ("INSERT INTO payers (idNum, fullName, phNum, email, address, city, state, zip, numAdults, numChilds, cardLast4, cardExpM, cardExpY, small, medium, large, xl, 2xl, 3xl, reunionDocumentary) VALUES ('".$payerIdNum."', '".$payerName."', '".$payerPhNum."', '".$payerEmail."', '".$payerAddress."', '".$payerCity."', '".$payerState."', '".$payerZip."', '".$payerNumAdults."', '".$payerNumChilds."', '".$payerCardLast4."', '".$payerCardExpM."', '".$payerCardExpY."', '".$payerSmall."', '".$payerMedium."', '".$payerLarge."', '".$payerXl."', '".$payer2Xl."', '".$payer3Xl."', '".$payerReunionDocumentary.")");
	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 ($i=0; $i<30; $i++) {
				$IdNum .= chr(mt_rand(35, 126));
			}
			mysql_query ("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES ('".$IdNum."', '".$payerIdNum."', 'adult', '".$fullName."', '', '".$phNum."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$shirtSize.")");
		} 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 ($i=0; $i<30; $i++) {
				$IdNum .= chr(mt_rand(35, 126));
			}
			mysql_query ("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES ('".$IdNum."', '".$payerIdNum."', '".$adult_child."', '".$fullName."', '".$parent_guardian."', '".$phNum."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$shirtSize.")");
		}
	}
	mysql_free_result($row_RR);
}