is there as mysql_ version of mysqli_more_results?

[MrKrinkle]

mysqli has mysqli_more_results(). What is the equivalent function in
the older mysql extension?

[petermichaux]

How are you today?

[Oli Filth]

MrKrinkle said the following on 26/06/2005 16:19:

mysqli has mysqli_more_results(). What is the equivalent function in
the older mysql extension?

There isn't one!

MySQLi library has support for multiple queries, hence the need for
mysqli_more_results(). The old MySQL library can't perform multiple
queries, hence no need to find if there are more result sets to obtain.

--
Oli

[MrKrinkle]

Darn. So I can't implement Iterator on my mysql query class. Cause I
can't implement valid().

[MrKrinkle]

And by the way, there's still a need to find out if there's more
results left even if you're only doing one query. mysql_fetch_assoc()
will give you the next record in the results list. So there would be a
use in knowing "are there any more records in the results list?"

[Oli Filth]

MrKrinkle said the following on 26/06/2005 21:11:

And by the way, there's still a need to find out if there's more
results left even if you're only doing one query. mysql_fetch_assoc()
will give you the next record in the results list. So there would be a
use in knowing "are there any more records in the results list?"

Yes, but that's a fundamentally different thing to finding how many
result *sets* are left, which is what mysqli_more_results() does.

mysql_fetch_assoc() et al. all return FALSE when there are no more rows,
so that's one way of doing this. Alternatively, use mysql_num_rows()
straight after the query, and decrement it every time you fetch a row,
checking for when it reaches zero.

--
Oli

[MrKrinkle]

Ah, I'll try the decrement then, thanks.

[MrKrinkle]

Ah, I'll try the decrement then, thanks.