returning an sql entry

[berrance]

right i am inputting a antryp to my database using the following code which works well

$query1 = "insert into topic (description, forum_id, starter)
          values 
            ('$topic', '$forum', '$username')";

$result1 = $handle->query($query1)

hears the problem, i need it to return the ID field from the record just created.

can any one help please

thanks

berrance

[mrhappiness]

[man]mysql_insert_id[/man]

hth

[berrance]

thanks for that but when using

mysql_insert_id();

i get the following error

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in /mnt/raid5-1/www/htdocs/forum/postthread.php on line 26

this is what i put after the query i posted before

$test = mysql_insert_id();

echo = $test;

thanks for any help

berrance

[mrhappiness]

i don't no which database you use, what you database class looks like, ... so you have a little bit more to tell 😉