[RESOLVED] get auto_increment id

[fearfx]

when I add a new row to my db it automatically creates a new auto_increment id,

now how can I get this id while the same insert query is running?

		$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
		mysql_select_db($mysql_database, $bd);
		mysql_query("INSERT INTO {$prefix}pages (user_id,url,title,description,keywords,ban_link,ban_img_link,accepted,category,comment,briefcase,menu_1,menu_2,menu_3,menu_4,menu_5) VALUES ('{$user_id['id']}','$url','$title','$description','$keywords','$ban_link','$ban_img_link','n', $c, '$c_url', '$b_url', '$men_1', '$men_2', '$men_3', '$men_4', '$men_5')");

thats my insert query... now right after this what should I do to get the id that was just inputed?

[laserlight]

Use [man]mysql_insert_id/man, but of course it only applies to just after the insert, not the "same insert".

[fearfx]

Im not quit sure what you mean, you do know what I am looking for?

[fearfx]

I guess what I want is to get the id from the same insert so I can apply that ID to a HTML link...

[laserlight]

Have you read the PHP manual's entry on mysql_insert_id()? I linked to it in my previous post in this thread.

[fearfx]

sorry I missed that... Thank you very much!