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
> -----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
> 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
> > sure
> > if it works on non-numbers, you'd have to look it up in a SQL
> > 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
> > my
> > ISP had problems with e-mail and I lost dozens of them and don't
> > sent OK.
> > Hi all,
> > What I'm trying to do here is not inside PHP nor MySQL books I have.
> > need
> > to query the DB to look the max result in a column. That is, if I
> > affiliate members with ID going from 1 to 10, get the query to know
> > 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
> > 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