Re: php mysql max() question

>     On Sun, 2009-04-12 at 15:13 -0700, A. W. Wright wrote:
>     > Craig White wrote:
>     > > just want the max of an integer field ultimately into a variable.
>     > >
>     > > <?php
>     > >   $MaxSalesOrders = 'SELECT MAX(orderno) FROM salesorders;';
>     > >   mysql_connect("$HOST", "$USER", "$PASSWD");
>     > >   mysql_select_db("lighting_unlimited");
>     > >   $MaxSalesOrdersResult = mysql_query($MaxSalesOrders);
>     > >   mysql_close();
>     > >   echo var_dump($MaxSalesOrdersResult) . " - " . \
>     > >    $MaxSalesOrdersResult;
>     > > ?>

>     > >
>     > > seems pretty straight forward. In mysqlclient, the answer is
>     of course
>     > > returned - perhaps as a row, I'm never quite sure.

>     > >
>     > > The code above returns the following in a browser...

>     > >
>     > > resource(6) of type (mysql result) - Resource id #6

>     > >
>     > > and I've been trying all sorts of things 'SELECT AS...' and
>     Googled for
>     > > several hours and I'm sort of convinced that what is being
>     returned from
>     > > the sql query is neither an array, nor string and has to be
>     converted
>     > > into a variable that is useful to me.

>     > >
>     > > Anyone know how to do this (i.e. without pear-db)?

>     > >
>     > > Craig

>     > >
>     > mysql_query (and mysqli_query) doesn't actually give you the resuly,
>     > just a pointer to it. Use the mysql_fetch_assoc (returned array
>     indexed
>     > by column name) or mysql_fetch_row (indexed by column order)
>     function to
>     > get that, and see http://us2.php.net/mysql_query for more
>     information.
>     ----
>     yeah that was it. I was sort of looking at that, trying to
>     decipher the
>     api of the software I was working on and then creating my own
>     connections out of the program so I could test bits of code. I'm
>     easily
>     confused I guess.  ;-)

>     One thing is certain, I have been spoiled by ruby on rails and php
>     just
>     seems so crude and ugly now.

>     Thanks

>     Craig

>     --
>     This message has been scanned for viruses and
>     dangerous content by MailScanner, and is
>     believed to be clean.

>     ---------------------------------------------------
>     PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>     <mailto:PLUG-discuss@lists.plug.phoenix.az.us>
>     To subscribe, unsubscribe, or to change your mail settings:
>     http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss