this is a mysql query for heighest id, maybe it helps
// get highest ID from database
include 'includes/connect.php';
$query1=MYSQL_QUERY("SELECT max(id) as max_id FROM $ctableuk");
$getvar=MYSQL_FETCH_ARRAY($query1);
$id=$getvar["max_id"];
mysql_close();
if (!isset($id)){$id="1";}
"Generalx" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
