mysql_query(

[Anon]

When I have more than one mysql_query() in a single script. The last one won't execute. I don't get an error. It just doesn't work. It doesn't matter whether I have 2,3,4, etc.. the last one in the line won't execute.
Here's an exaple of the code.
It loops through two arrays to create the SQL statement and then executes. THe db connection is global.
I've spent days trying to figure this out. Please help.
Thanks,
mf

---

<?php

//##############################################################################
// if it passes all the tests then we insert the info into Customer and Practice Tables
// Also a joined table between the Customer and Practice
// then an email is sent out, the customer is not made live until the user logs in for the first time.
//##############################################################################

//Inserts the data
//Creates an Customer and Practice ID

$CustomerID = md5(uniqid(rand()));
$PracticeID = md5(uniqid(rand()));
$Date = date("Y-j-m H:i:s");

//Runs through the insertProfile Array in order to create the SQL INSERT Statement
$queryPractice = "Insert into PracticeProfile Set ";
$queryPractice .= "CustomerID = '$CustomerID ', ";
$queryPractice .= "PracticeID = '$PracticeID ', ";

while ( list($key, $value) = each($InsertPractice))
{
$queryPractice .= "$key = '$value', ";
}

$queryPractice .= "DateAdded = '$Date'";

$resultPractice = mysql_query($queryPractice);

//Runs through the insertClient Array in order to create the SQL INSERT Statement

$queryClient = "Insert into CustomerAccounts Set ";
$queryClient .= "CustomerID = '$CustomerID ', ";
$queryClient .= "Live = 'N', ";
while ( list($key, $value) = each($InsertClient))
{
$queryClient .= "$key = '$value', ";
}

$queryClient .= "DateAdded = '$Date'";

$resultClient = mysql_query($queryClient);

//sends email to the user with confirmation

	$Subject = "Welcome to Eorthopod.";
	$Body = "This is a test.";
	$Recipient = $InsertClient[CEmail];
	$Sender = "[e-mail]";
	//Sends a confirmation mail to the customer with the password
	mail($Recipient, $Subject, $Body, $Sender);

	//redirects to the Confirmation page
	Header("Location: Confirmation.php?queryClient=$queryClient&queryPractice=$queryPractice"); 

?>

[Anon]

Or even if I just have the 2 line right next to each other, only the first one executes.
i.e.

---

$resultClient = mysql_query($queryClient);
$resultPractice = mysql_query($queryPractice);

[beettlle]

I had the same problem a while back. I guess it has t odo with the way MySQL handles that sort of thing. ON your first post I didn't see where you connect to your DB(I'm guessing you have it on an include file). Ok, the way I fixed it, and I know it's not the sexiest way, is to connect a to the DB right before each mysql_query(). So you'd try this:

<?php
include("connect_to_DB.inc") ;
/The connect functions comes out to $dbh /

$resultClient = mysql_query("$queryClient" , $dbh) ;
/get results from that to some array with mysq_fetch_array/
$resultPractice = mysql_query("$queryPractice", $dbh);
/then get resutls from this to another array with mysq_fetch_array/
?>

That's how I got it to work. So you'd need 2 connections to the DB for this example. Anyone got a better idea?

[Anon]

Thanks Beeettlle. But, yeah, I tried that. The connection is done thru an include. I've tried calling it in front of mysql_query() and I've tried putting the query's in all different orders It still isn't working. Another weird (infuritating) thing that seems to be happening is that the statement which isn't executing isn't actually the last statement. It appears to be happening at random. Sometimes the first statment executes, some time the later statement.

Anyone else?
-mf

Beettlle wrote:

I had the same problem a while back. I guess it has t odo with the way MySQL handles that sort of thing. ON your first post I didn't see where you connect to your DB(I'm guessing you have it on an include file). Ok, the way I fixed it, and I know it's not the sexiest way, is to connect a to the DB right before each mysql_query(). So you'd try this:

<?php
include("connect_to_DB.inc") ;
/The connect functions comes out to $dbh /

$resultClient = mysql_query("$queryClient" , $dbh) ;
/get results from that to some array with mysq_fetch_array/
$resultPractice = mysql_query("$queryPractice", $dbh);
/then get resutls from this to another array with mysq_fetch_array/
?>

That's how I got it to work. So you'd need 2 connections to the DB for this example. Anyone got a better idea?

[mfitzgerald]

But he/she is cruel and unusual. Beettle it is now apparently working the way you siad to try, but only after I added and enry to both tables by hand (through the command prompt interface.)
Still...
thanks,
mf

[beettlle]

What kinda changes did you ahve to do to the table? I'm just wondering 'cause it's never bad to know just in case it happens to me again becasue I can't find the original script that gave me that trouble. It was a test so probably got deleted in my TMP folder. Glad it worked though, =)