Jump to content

[SOLVED] mysql_query


isaac_cm

Recommended Posts

no, I mean does mysql_query return a complete cached or buffered record set  of the table or not ?

 

if it is not cashed all records then during a loop any insert, update or delete will be visible in this record set which I don't want because I making changes during the loop to the table

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/70190-solved-mysql_query/#findComment-353364
Share on other sites

Hi,

mysql_query() automatically buffers whole selected record set. Unbuffered equivalent of this function is mysql_unbuffered_query(). If you would use mysqli interface be careful, because mysqli_query() has no mysqli_unbuffered_query() equivalent, instead you need to use mysqli_query(..., ..., MYSQLI_USE_RESULT) or mysqli_real_query() and mysqli_use_result().

 

Michal

Link to comment
https://forums.phpfreaks.com/topic/70190-solved-mysql_query/#findComment-353834
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.