php mysql max() question

[Craig White]

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.