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