note 92245 added to function.mysql-insert-id
| From: | LibioBalbin at osu1 dot php dot net | Date: | Wed, 15 Jul 2009 18:18:52 +0000 |
| Subject: | note 92245 added to function.mysql-insert-id | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-158346@lists.php.net to get a copy of this message | ||
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
----
Server IP: 117.104.162.229
Probable Submitter: 190.12.67.162 (proxied: 190.12.67.162)
----
Manual Page -- http://www.php.net/manual/en/function.mysql-insert-id.php
Edit -- https://master.php.net/note/edit/92245
Del: integrated -- https://master.php.net/note/delete/92245/integrated
Del: useless -- https://master.php.net/note/delete/92245/useless
Del: bad code -- https://master.php.net/note/delete/92245/bad+code
Del: spam -- https://master.php.net/note/delete/92245/spam
Del: non-english -- https://master.php.net/note/delete/92245/non-english
Del: in docs -- https://master.php.net/note/delete/92245/in+docs
Del: other reasons-- https://master.php.net/note/delete/92245
Reject -- https://master.php.net/note/reject/92245
Search -- https://master.php.net/manage/user-notes.php