The ability to select a set from a previously selected set is possible in
Sybase because the database supports creation of temporary tables and the
select insert.
PHP (which is often packaged with MySQL) does not attempt to mix database
(SQL) with it's own scripting language (unless someone is working on this).
ASP on the other hand will sell you anything that consumes resources thereby
encouraging you to buy the bigger software, requiring bigger hardware (An
old IBM marketing plan, and my personal opinion). When you talk about a
result set in PHP you must be referring to what is returned by MySQL, not
PHP. Perhaps someday MySQL will have temp tables and SELECT INSERT
capability.
On the other had PHP does a very nice job of looping thru the result set.
Warren Vail
-----Original Message-----
From: Herouth Maoz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 11:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Problem: Sybase, PHP and multiple result sets
I have started working with Sybase lately, and it has come to my
knowledge that a single query can return multiple result sets in
Sybase, especially when using stored procedures.
Now, in ASP (sorry...), there are calls that allow retrieving the
next result set from the current result set. So in effect the result
sets are a linked list and you can access all of them.
In PHP, however, the result set returned is the first one, and I
don't see any method for retrieving the next result set. Does anybody
know of such a method? Does anybody have a suggestion for workaround?
Basically, in most of these cases, the important result set is
actually the last one, not the first, as the intermediate result sets
are mostly temporary results.
Herouth
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
