Just note that this will fail miserably unless you are locking your tables around the SELECT MAX() and the INSERT. What if 3 different users all select the same MAX() and try to insert the next number?
You really need to re-think your database design if you have to do it this way. ---John Holmes... > -----Original Message----- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 2:51 PM > To: 'PHP DB List'; 'PHP General List' > Subject: RE: [PHP] Querying for MAX > > Thanks Natalie & Ed. This Works just fine. > > What I want to do, is let a person subscribe new affiliates without > having to look up what the last affiliate's number was and show the next > one in the "new affiliate" form. > > César Aracena > IS / MCSE+I > Neuquén, NQN > (0299) 156-356688 > (0299) 446-6621 > > > -----Mensaje original----- > > De: Leotta, Natalie (NCI/IMS) [mailto:[EMAIL PROTECTED]] > > Enviado el: Miércoles, 12 de Junio de 2002 03:39 p.m. > > Para: 'César Aracena'; 'PHP DB List'; PHP General List > > Asunto: RE: [PHP] Querying for MAX > > > > is > > > > select MAX(<column name>) > > > > what you are looking for? I know it works on numeric columns, I'm not > > sure > > if it works on non-numbers, you'd have to look it up in a SQL Tutorial > > somewhere. > > > > Good luck! > > > > -Natalie > > > > -----Original Message----- > > From: César Aracena [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 12, 2002 2:36 PM > > To: 'PHP DB List'; PHP General List > > Subject: [PHP] Querying for MAX > > > > > > I'm sorry if this mensaje is posted twice. I sent it yesterdays, but > then > > my > > ISP had problems with e-mail and I lost dozens of them and don't know > if > > sent OK. > > > > > > Hi all, > > > > What I'm trying to do here is not inside PHP nor MySQL books I have. I > > need > > to query the DB to look the max result in a column. That is, if I have > > affiliate members with ID going from 1 to 10, get the query to know > that > > the > > last member added was 10 so I can add member 11 without using > > auto_increment, because I need to insert old members too which already > > have > > ID numbers. Is that possible? > > > > Thanks in advance, > > > > > > Cesar Aracena <mailto:[EMAIL PROTECTED]> > > CE / MCSE+I > > Neuquen, Argentina > > +54.299.6356688 > > +54.299.4466621 > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
