Re: [PHP] Re: Re: Getting last record ID created from DB

2007-03-19 Thread Richard Lynch
On Sat, March 17, 2007 9:48 am, Mark wrote: > I often wonder, looking at these questions, what is the state of the > web? If > any notable percent of it is written with this much basic ignorance of > computing, then the web is basically broken. The web *IS* basically broken. But large chunks of i

[PHP] Re: Re: Getting last record ID created from DB

2007-03-17 Thread Mark
Colin Guthrie wrote: > Mark wrote: >>> select user_id from t_users where user_id = (select max(user_id) from >>> t_users) >>> >> >> It should be noted that that is the absolute 100% WRONG way to do it. If >> your site has any concurrency, you will almost certainly get the wrong >> user. > > I ag