Re: [PHP] R: [PHP][PEAR] PEAR::DB_Common::nextId()

2004-01-16 Thread John W. Holmes
[EMAIL PROTECTED] wrote: Hello Not sure if you thought of it or if it even applies to you but when you use PEAR::DB::getOnce("SELECT LAST_INSERT_ID()"); to retrieve the id do consider concurrent access to the database when using it for inserting stuff. Been there and its a hassle to resolve th

Re: [PHP] R: [PHP][PEAR] PEAR::DB_Common::nextId()

2004-01-16 Thread SLanger
Hello Not sure if you thought of it or if it even applies to you but when you use PEAR::DB::getOnce("SELECT LAST_INSERT_ID()"); to retrieve the id do consider concurrent access to the database when using it for inserting stuff. Been there and its a hassle to resolve this little huge bug ; ) Con

Re: [PHP] R: [PHP][PEAR] PEAR::DB_Common::nextId()

2004-01-15 Thread David T-G
Alessandro -- ...and then Alessandro Vitale said... % % hi, Hi! % % thanks to Rory for his suggestion. % sure "mysql_insert_id()" could help. but I was looking for some trick for % accessing the result of that function without having to deal to % "mysql_connect()" again. But how will you que

[PHP] R: [PHP][PEAR] PEAR::DB_Common::nextId()

2004-01-15 Thread Alessandro Vitale
hi, thanks to Rory for his suggestion. sure "mysql_insert_id()" could help. but I was looking for some trick for accessing the result of that function without having to deal to "mysql_connect()" again. and i found it: PEAR::DB::getOnce("SELECT LAST_INSERT_ID()"); doesn't work perfectly but is ok.