should be something like :
    select max(is) as id, ...
----- Original Message -----
From: "GeneralX" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to