note 92245 deleted from function.mysql-insert-id by danbrown
| From: | danbrown@php.net | Date: | Wed, 15 Jul 2009 18:28:22 +0000 |
| Subject: | note 92245 deleted from function.mysql-insert-id by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-158347@lists.php.net to get a copy of this message | ||
Note Submitter: Libio Balbin
----
To know the last ID I do this:
<?
function viewLastID($id,$table,$link)
{
$result1 = mysql_query("SELECT $id FROM $table order by $id desc LIMIT 1",
$link);
while ($rowID = mysql_fetch_array($result1))
{
return $rowID[Id];
}
mysql_free_result($result1);
}
$last_id=viewLastID('your_name_id','your_name_table',$link);
echo $last_id;
?>
Regards.
www.KingPeru.NET