PHP another mysql_insert_id() not working

[JnrJnr]

Hi,
I have one database connection
I am using an insert statement
The insert statement inserts successfully
Right after the insert I want the ID of the newest row
My database table has a unique ID and set to auto inc
mysql workbench version is 5.2.34

$save = mysqli_query($connection,"insert into table (message, title, newdate) values ('$Message', '$itle', CURDATE())");
    $newid =  mysql_insert_id($connection);echo('val is '. $newid);

The value of $newid is always empty or 0
Please help!

[Joseph Cobham]

why don you try some thing of this nature it works perfectly for me

$query = "INSERT into `table` (`message`,`title`,`newdate`)
    VALUES
('$message','$title', CURDATE())";
 
mysql_query($query,$connection) or die("Insertion Failed:" . mysql_error());
$newest_id = mysql_insert_id($connection);

and dont forget to escape your query data using mysql_real_escape_string()

If you find any error let me know

[Dormilich]

in case you didn’t notice:

 $save = mysqli_query($connection,"insert into table (message, title, newdate) values ('$Message', '$itle', CURDATE())");
// -----------^ 
$newid = mysql_insert_id($connection);echo('val is '. $newid);
// -----------^