Getting last ID inserted into DB - value returned is "array" string?

[dbrewerton]

Hello folks, I'm trying to figure out how to get the last inserted ID from my database. The query runs but instead of getting the actual number inserted, I get the word Array returned. Here's the code, let me know how to fix this. Thanks! For what its worth, this is MySQL running PHP and the DB connection I believe is PDO.

	$query = $db->prepare("SELECT id from orders ORDER BY id DESC LIMIT 1");
	$query->execute();
	$order_number = $query->fetch();
	$order_number++;

[dbrewerton]

I finally figured it out. I had to query that Last Inserted ID outside the MySQL Execute statement.