Single or multiple mysql function calls ?

taffer

Quick question:

Is there an elegant way to execute the following SQL with only one PHP mysql function call?

--SQL--

SET @var_a = 0;
SET @var_b = 0;
SET @var_c = 0;
SELECT * FROM table_abc WHERE col_a = @var_a AND col_b = @var_b AND col_c = @var_c;

--SQL--

Since I only want to parse the results of the final query.

... or is the only solution with PHP to call mysql_query() four times ?

Thanks in advance.

Danicek

I think you can send just as one query. There should be no problem.

superwormy

With PHP, you cannot presently make more than one SQL statement with a single call to mysql_query();

You'll need to do more than one call to mysql_query();

Danicek

Seems, that I do not too much about PHP. I supposed that you can make only one call "that returns something" in mysql_query();

taffer

Originally posted by superwormy
With PHP, you cannot presently make more than one SQL statement with a single call to mysql_query();

You'll need to do more than one call to mysql_query();

Thank you for clarifying that. I'll just have to wait for mySQL 5.0 then with the hoped for stored procedure support 🙂

superwormy

...?

What does MySQL 5.0 have to do with a PHP limitation?

Also... why can't you just run more than one query?

keith73

Originally posted by taffer
Quick question:

Is there an elegant way to execute the following SQL with only one PHP mysql function call?

--SQL--

SET @var_a = 0;
SET @var_b = 0;
SET @var_c = 0;
SELECT * FROM table_abc WHERE col_a = @var_a AND col_b = @var_b AND col_c = @var_c;

--SQL--

Since I only want to parse the results of the final query.

... or is the only solution with PHP to call mysql_query() four times ?

Thanks in advance.

why are you setting vars in mysql, seems like a waste. If you're accessing mysql from a php script, just build your query in php like so:

$query = "select * from table_abc where a = $a AND b = $b AND c = $c";
$result = @mysql_query($query);
while ( $row = mysql_fetch_object($result) ){
    //parse results here
}//end while

keith

taffer

Originally posted by superwormy
...?

What does MySQL 5.0 have to do with a PHP limitation?

Also... why can't you just run more than one query?

mySQL5.0 should have support for stored proceedures, allowing hopefully mysql_query("EXECUTE sp_SQL_STATEMENTS");

I didn't want multiple queries, because I am intending to run the queries multiple times (thousands, possibly millions per hour) - also the reason for the inclusion of variables is that the actual statements are much more complicated than the example listed above and involve recursive data structures. A pure SQL script can perform as required on mySQL AND MS SQL Server.

The desired solution will now be implemented as a cron job and a WSH task - I thought it would be nice to integrate it with other PHP code - and still may, but using multiple queries (for step-by-step) executions.

Thank you to all for your feedback.