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-DB] 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 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:[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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
