[PHP-DB] RE: [PHP] Querying for MAX From: César Aracena (caracena <email protected>)
Date: 06/12/02

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:LeottaN <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:caracena <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:webmaster <email protected>>
> CE / MCSE+I
> Neuquen, Argentina
> +54.299.6356688
> +54.299.4466621 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php