Show your code and learn how to use the MySQL_fetch_array() function...
> -----Original Message-----
> From: César Aracena [mailto:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> > Enviado el: Miércoles, 12 de Junio de 2002 05:13 p.m.
> > Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Asunto: [PHP] Re: Querying for MAX
> > select max(id) as amount from table
> > "César aracena" <[EMAIL PROTECTED]> wrote in message
> > 003301c21240$0cdcf790$89c405c8@gateway">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
> > know if sent OK.
> > Hi all,
> > What I'm trying to do here is not inside PHP nor MySQL books I have.
> > need to query the DB to look the max result in a column. That is, if
> > have affiliate members with ID going from 1 to 10, get the query to
> > that the last member added was 10 so I can add member 11 without
> > auto_increment, because I need to insert old members too which
> > 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 General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php