Re: ODBC Query max()
| From: | Joe Goff | Date: | Sat, 15 Mar 2003 04:51:43 +0000 |
| Subject: | Re: ODBC Query max() | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19015@lists.php.net to get a copy of this message | ||
should be something like :
select max(is) as id, ...
----- Original Message -----
From: "GeneralX" <song@isot.com>
To: <php-windows@lists.php.net>
Sent: Friday, March 14, 2003 11:46 PM
Subject: [PHP-WIN] ODBC Query max()
> I'm trying to extract one record that has largest sequence ID number for
an
> employee, so I've tried below but doesn't work. Help.
>
> $mQuery = "EmployeeID = '$user'";
> $mCur = odbc_exec( $mCnx, "select ID=max(ID),Date,TimeIn,TimeOut,StationIP
> from Clocks where $mQuery" );
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>