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