in reply to UPDATE WHERE oid = $oid
As the last record to come off this query should be the one with the latest time stamp - $latest_oid will have the corresponding oid.$sql='select oid,time'; $sql.='from clock'; $sql.='order by time'; $exec=$dbh->prepare($sql); $exec=$dbh->execute()||die "Query Failed\n$sql\nError:\n$DBI::errstr"; while ($res=$exec->fetch) { $latest_oid=${$res}[0]; }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: UPDATE WHERE oid = $oid
by runrig (Abbot) on Jul 20, 2001 at 01:26 UTC |