mysql_insert_id()

[Anon]

I'm using MySQL 3.22.32 and php 4.1.1. I'd like to get the id number back after an insert query.

here's my field: id int(10) UNSIGNED NOT NULL auto_increment

Code:

SQLStr = "INSERT into ref_journals (authors, title, journal) VALUES ('" . $authors . "', '" . $title . "', '" . $journal);";

$result = mysql_query($SQLStr)

The result (after a successful insert):

echo mysql_insert_id(); and

$query = "SELECT LAST_INSERT_ID()";
$updateID = mysql_query($query)

both return 0

what am I doing wrong?

thanks,
--Brian

[Anon]

BTW...the auto_increment field is also defined as primary key....phpmydmin doesn't show that.

[[deleted]]

Are you sure the INSERT worked?

[Anon]

yes...that's a tersified example of the insert query. The insert does work, I write it back out the screen before I write the insertID out to the screen, so I can verify it's working -- and it is.