[SOLVED] mysql_query

[isaac_cm]

hello,

I need to loop over a record set and I need to know if the record set that returned by mysql_query whether if a separate record set from the physical table (cashed for example) or any updates in the table will be reflected immediately on this record set ?

 

Thanks

[teng84]

not clear but i guess all you have to do is to get the time interval of each recodr to see how many has added or updated 

[isaac_cm]

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

[mezise]

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

[isaac_cm]

are you sure it buffer all the record set not just part of it ?,

 

Thanks

[mezise]

Yes, I'm sure.

 

Michal

[isaac_cm]

ok, thanks