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

When I try to use this SELECT MAX(column) AS amount FROM table; with
PHP, the result I get is always: "Resource id #2" and not the number I
expect... but if I run this at the mysql command line, it shows the
expected number/value. What is that?

César Aracena
IS / MCSE+I
Neuquén, NQN
(0299) 156-356688
(0299) 446-6621

> -----Mensaje original-----
> De: Leon Mergen [mailto:leon <email protected>]
> Enviado el: Miércoles, 12 de Junio de 2002 05:13 p.m.
> Para: php-general <email protected>; php-db <email protected>
> Asunto: [PHP-DB] Re: Querying for MAX
>
> select max(id) as amount from table
>
> "César aracena" <caracena <email protected>> wrote in message
> news:003301c21240$0cdcf790$89c405c8 <email protected>
> 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 

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