Submitting a form via javascript, how to get the id of the last post?

Question

PHP

if you just pass echo "1" - then in alert (data) - shows 1, and if

$query = "SELECT id FROM `post` ORDER BY id DESC Limit 0,1";
$result = mysql_query($query) or die(mysql_error());
echo $result['id'];

it's empty. (there are records in the database, I tried it in SQL - it returns, for example, id: 141)

Answer 1

Thanks for the correction, this is how I solved it.

$query = "SELECT `id` FROM `post` ORDER BY `id` DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_assoc($result);
echo $array['id'];

Answer 2

The mysql_query function returns a resource, not a query result. See example #2 php.net/manual/en/function.mysql-query.php

Answer 3

"SELECT `id` FROM `post` ORDER BY `id` DESC LIMIT 1"