Re: I can't seem to get Max() to work
| From: | Robby Russell | Date: | Thu, 28 Oct 2004 06:52:58 +0000 |
| Subject: | Re: I can't seem to get Max() to work | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37062@lists.php.net to get a copy of this message | ||
On Thu, 2004-10-28 at 01:05 -0400, Chris Payne wrote:
> Hi there everyone,
>
>
>
> I can’t seem to get the below to work with PHP and MySQL:
>
>
>
> $sql = "SELECT MAX(FoodItemNumber) FROM menuitemsubs";
>
>
>
> What am I doing wrong? I need the highest number from the column
> FoodItemNumber, but it doesn’t return anything unless I change the MAX() to
> a * and I don’t want that I need it to be the MAX() number as it isn’t an
> auto-increment field.
Is this an integer field?
-Robby
--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 and PHP4 ---
****************************************/
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc