call same function twice combines values

viveleroi0

I have a single MySQL query function that I call twice in one php form, (once to perform a SELECT query and once for an UPDATE). The issue is, PHP 5.0.2 combines the two queries that I pass to the function and then the query fails because SELECT * FROM tableUPDATE table SET field="data" is not a valid query.

I have tried using unset() to unset the function variables but nothing works. I need to know how to keep two function instances seperate.

devinemke

post the code

viveleroi0

This is the code:

	$DB = new DB_Connect;
	$DB->MysqlConnect($db['CONNECT']['HOST'],$db['CONNECT']['USER'],$db['CONNECT']['PASS']);
	$DB->MysqlSelectDB($db['CONNECT']['DBASE']);

$Query = "SELECT phone_num FROM calltracking WHERE phone_ac=\"0\"";
$DB->MysqlRunQuery($Query);
$DB->MysqlQueryRows();


for($i = 0; $i < $DB->result_rows; $i++){

	$DB->MysqlResultArray();

	$pieces = explode("-", $DB->results['phone_num']);

	$save="UPDATE calltracking
	SET phone_ac=\"$pieces[0]\",
	phone_pre=\"$pieces[1]\",
	phone_suf=\"$pieces[2]\"
	WHERE phone_num=\"$phone\"";
	$DB->MysqlRunQuery($save);

}

Attached is the class this references. When run under PHP 5.0.2 and MySQL 4.1.7 $DB->MysqlRunQuery combines the two queries.

viveleroi0

can anyone help?

tsinka

Hi,

did you enable the mysqli extension or the mysql extension ?

Thomas

viveleroi0

I am using and have my code using mysqli

Through testing I found that when I perform a query using the above class, and then make a loop using the rows returned from QUERY #1, and I add a second query within that loop, the class combines the queries.

For example I have a loop that prints four rows. Thus, there are five queries - the intial query to get the four rows from one table, and a second query to update a different table once for each of the four results.

When I add print $query; to the class, it prints five queries combine together:

the first one, and then each of the four afterwards.

tsinka

Test this one:

$DB = new DB_Connect;
$DB2 = new DB_Connect;
    $DB-> MysqlConnect($db['CONNECT']['HOST'],$db['CONNECT']['USER'],$db['CONNECT']['PASS']);

$DB2->MysqlConnect($db['CONNECT']['HOST'],$db['CONNECT']['USER'],$db['CONNECT']['PASS']);
$DB->MysqlSelectDB($db['CONNECT']['DBASE']);
$DB2->MysqlSelectDB($db['CONNECT']['DBASE']);

$Query = "SELECT phone_num FROM calltracking WHERE phone_ac=\"0\"";
$DB->MysqlRunQuery($Query);
$DB->MysqlQueryRows();

for($i = 0; $i < $DB->result_rows; $i++){

    $DB->MysqlResultArray();

    $pieces = explode("-", $DB->results['phone_num']);

    $save="UPDATE calltracking
    SET phone_ac=\"$pieces[0]\",
    phone_pre=\"$pieces[1]\",
    phone_suf=\"$pieces[2]\"
    WHERE phone_num=\"$phone\"";
    $DB2->MysqlRunQuery($save);

}

You might be messing up the result data in $DB by executing the second query.

Besides that it might be possible to do the same with just one query because you can use joins in UPDATE statements with MySQL 4.1.x (and certain 4.0.x versions).

Thomas

viveleroi0

That has the same result. I had tried that already, but I just tried it again to make sure I didn't miss anything.

I would use just one query the problem is that I am refromatting data. I am taking a phone number and splitting up the whole number in three smaller parts, then saving those numbers into three other fields in the same table.

If MySQL has a way to split up a number at each hyphen and save the results into three fields, I would love that.

But the issue is that I will have other sections where one query just has to be in the loop of the other.

I need to find out why this is happening. It only is an issue when the second query is in a loop.

If I take the second query out of the loop, both queries work fine.