Querying for MAX
| From: | César Aracena | Date: | Wed, 12 Jun 2002 18:36:14 +0000 |
| Subject: | Querying for MAX | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-19762@lists.php.net to get a copy of this message | ||
Im 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 dont
know if sent OK.
Hi all,
What Im 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@icaam.com.ar>
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621