|
|
Posted by Jeff on 01/22/07 19:01
Hey
I use php 5.2.0 and via this php code I call a stored procedure (see the
code below):
This stored procedure inserts a new record into table (mysql5 database). The
problem is that $db->insert_id don't give the id of the newly inserted
record in the table, it gives the value 0
This is the declaration of the primary key column on this table
Id int unsigned not null auto_increment primary key
$sql = "call SaveProperty(".$_SESSION['userId'].", '".$adresse."')";
echo $sql;
$result = $db->query($sql);
echo "NEW ID = ".$db->insert_id;
if (mysqli_errno($db))
{
$error = mysqli_error($db);
echo $error;
}
Any suggestions?
Navigation:
[Reply to this message]
|