Come to think now, you are all right about making the field auto_increment, instead of asking the DB which one is the following number. It's just that I have a pretty large old DB in which this field is NOT in sequence and should be imported before I keep designing the scripts.
Thanks to all of you who helped me. César Aracena IS / MCSE+I Neuquén, NQN (0299) 156-356688 (0299) 446-6621 > -----Mensaje original----- > De: John Holmes [mailto:[EMAIL PROTECTED]] > Enviado el: Miércoles, 12 de Junio de 2002 08:51 p.m. > Para: 'César Aracena'; 'PHP DB List'; 'PHP General List' > Asunto: RE: [PHP] Querying for MAX > > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php