Re: [PHP-DB] Taking care of an auto_increment field!

2006-07-06 Thread Chris
Is there a way to use transactios in MySQL?? Of course. They only work properly with innodb tables though. This is all in the mysql documentation (http://dev.mysql.com) Or maybe using a global variable accesed by all the processes running in the server? You could create a global 'sequen

[PHP-DB] Taking care of an auto_increment field!

2006-07-06 Thread Miguel Guirao
Hi pals, I have a module in my PHP application that creates and id (string + the auto_increment field). I read the last auto_increment value from the table, then in my code I use it as the base to create a second id (the auto_increment field + string). This happens for as many hardware the u