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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
