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:
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
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
