Returning value from MySQL insert function

Question

I have a function, it writes to a mysql database. I can successfully write to the database, but I am having trouble reducing the unique id of the row in the database that it writes to.

And yes I know mysql queries are depreciated soon.

function newBorrow_request($newBorrowRequest) {
array_walk($newBorrowRequest, 'array_sanitise');

$fields = '`' . implode('`, `', array_keys($newBorrowRequest)) . '`';
$data = '\'' . implode('\', \'', $newBorrowRequest) . '\'';

$query = mysql_query("INSERT INTO `borrowRequest` ($fields) VALUES ($data)");
$id = mysql_insert_id(); //this is where the problem is
if (!$query) {
    die('Could not query:' . mysql_error());
}

return $id; //and here
} 

I call it in another file using this code: ($newBorrowRequest is an array with fields defined).

newBorrow_request($newBorrowRequest);

So essentially my question is: with the above code how can I return the id of the row I am inserting in to? (I don't want to echo it inside the function, it needs to be outside, in the sale file I originally call the function).

Answer 1

Simply *echo newBorrow_request($newBorrowRequest);*

It will display the $id. Meanwhile make sure your function page is included on the page you are getting the $id.

include "myfunctionpage.php"; echo newBorrow_request($newBorrowRequest);