see mysql_insert_id($link_identifier)

-- rylin

Patrik Fomin wrote:


im adding a post to the database, is there any way to retrive back the ID
for the post that i just created?

the id is auto_increment and primary key.

$sql = "insert into test (namn, www) values('test', '')";

$row = mysql_get_post("id");

the only way i could think of was to create a tempfield in the database and
each time you post you give the temp field a unique value, like:

$sql = "insert into test (namn, www, unique) values('test',

$sql = "select id from test where unique = '25323324'";
$res = mysql_query($sql);

regards patrick

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to