HELP: mysql_insert_id() problem

[halex]

<?php
mysql_connect($host,$user,$password);

$sql = "INSERT INTO USERTABLE (USERNAME,PSWD) ";
$sql .= "VALUES ('$username',PASSWORD('$password'))";
mysql_db_query("database",$sql); //perform INSERT

$newId = mysql_insert_id();
$sql = "SELECT * FROM USERTABLE WHERE ID = ".$newId;
$result = mysql_db_query("database",$sql);
if(mysql_num_rows($result) > 0) {
$user = mysql_fetch_array($result);
session_register("user");
}
mysql_free_result($result);

This is not working.
Well, "mysql_insert_id()" is making jokes with me and doesn't want to get right ID ("USERTABLE" has "ID" primary key field that is AUTO_INCREMENT). "user" row (filled with data) seems not set in session. Acctualy $user['ID'] = 0.
Where I'm wrong?

[trooper]

In order to find out whtat could be happening put

or(die(mysql_error()) ;

after the mysql_connect and also the mysql_query

that way you'll see if you have any errors

Originally posted by halex
<?php
mysql_connect($host,$user,$password);

$sql = "INSERT INTO USERTABLE (USERNAME,PSWD) ";
$sql .= "VALUES ('$username',PASSWORD('$password'))";
mysql_db_query("database",$sql); //perform INSERT

$newId = mysql_insert_id();
$sql = "SELECT * FROM USERTABLE WHERE ID = ".$newId;
$result = mysql_db_query("database",$sql);
if(mysql_num_rows($result) > 0) {
$user = mysql_fetch_array($result);
session_register("user");
}
mysql_free_result($result);

This is not working.
Well, "mysql_insert_id()" is making jokes with me and doesn't want to get right ID ("USERTABLE" has "ID" primary key field that is AUTO_INCREMENT). "user" row (filled with data) seems not set in session. Acctualy $user['ID'] = 0.
Where I'm wrong?

[halex]

Yes I know that and I am using my function for connection (down):

$BASESERVER = "localhost";
$BASEUSER = "a";
$BASEPASS = "a";
$BASENAME = "storage";

$db = mysql_connect($BASESERVER, $BASEUSER, $BASEPASS);
mysql_select_db($BASENAME,$db);

function my_query($sql) {
global $PHP_SELF;
global $db;

if(($result = mysql_query($sql,$db)) == 0) {
echo "\n<BR>MySQL error: <B>".mysql_error()."</B><BR>\n";
die("Query was (<B>$sql</B>) in file <B>$PHP_SELF</B>");
}
else
return $result;
}

And it works without any errors. Queries are OK. I resolved my problem with one more SELECT query like: "SELECT MAX(ID) FROM USERTABLE" after "INSERT" and I got NEWID and then perform new "SELECT * FROM USERTABLE". But I wanted with mysql_insert_id()