Using MySQL user-defined variables with database class

[eluser]EBS Promo[/eluser]
Look at it this way, you are doing an update with a single MySQL query instead of loading each record and updating them one at a time in a PHP loop.

I'm not sure about your experiences, but I have never seen it take less resources to do it your way. In case you misundertsand the code reference... no PHP loops are used, only 1 MySQL variable and a single query is necessary.

I have always been of the persuasion to use your database engine to it's full potential. Using PHP to do what the db driver can already do with simple commands is overkill.