Selecting the inserted result?

[Anon]

Hi all,
I tried to find my mistake on my own bu I couldn't so I am looking for your help!
I have an id which is auto incremented each time I insert a new row. How can I select the last inserted row which coresponds to the higher id?
Here is my code:
<?php $link=mysql_connect ( "dbase","user","pass") or die("1");
mysql_select_db('dbasename',$link) or die("2");
$result = mysql_query("select id,name from members order by id)") or die("3");
$go= mysql_fetch_array($result) or die("4");
$ids=$go["id"];
$names=$go["name"];
echo("&names=$names");
echo("&ids=$ids");
?>

[Anon]

Try something like this:

function Newest_Member() {

// The Newest Member display

global $config;

if($config[shownewestuser]) {
	$result = mysql_query("select uname from ps_users order by uid desc");
}

if($result) {
	list($newest_user) = mysql_fetch_row($result);
	echo sprintf(translate("Welcome %s, He is our newest user"),$newest_user);
}

}

I wrote this code for a project called pslash found at pslash.com and it selects the last member added to the database and I am sure you can change it to select all the data of the list entry and display it. Hope this helps.

[kparker]

mysql_insert_id() exists for precisely this purpose.

[Anon]

Thank you both! I found my mistake.