RE: [PHP] Re: Querying for MAX
| From: | John Holmes | Date: | Thu, 13 Jun 2002 00:32:31 +0000 |
| Subject: | RE: [PHP] Re: Querying for MAX | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-101848@lists.php.net to get a copy of this message | ||
Show your code and learn how to use the MySQL_fetch_array() function...
www.php.net/mysql_fetch_array
---John Holmes...
> -----Original Message-----
> From: César Aracena [mailto:caracena@infovia.com.ar]
> Sent: Wednesday, June 12, 2002 6:19 PM
> To: PHP DB List; PHP General List
> Subject: RE: [PHP] Re: Querying for MAX
>
> 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@antrophia.com]
> > Enviado el: Miércoles, 12 de Junio de 2002 05:13 p.m.
> > Para: php-general@lists.php.net; php-db@lists.php.net
> > Asunto: [PHP] Re: Querying for MAX
> >
> > select max(id) as amount from table
> >
> > "César aracena" <caracena@infovia.com.ar> wrote in message
> > news:003301c21240$0cdcf790$89c405c8@gateway...
> > 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@icaam.com.ar>
> > 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