Select max(id) issue

[LoserBhoy]

Am doing an insert amd then trying to generate the id of the srticle inserted so I an pass it to a preview page

$maxid =
"
SELECT MAX(id)
FROM celtic_news
";
$max_id = mysql_query($maxid) or die ("Error in query: $maxid.".mysql_error());
echo $max_id;

Max_id is always Resource id #2

any ideas?

Thanks.

[mad27]

Yeah. The $max_id you generate the resource where the results can be found. You forgot to do mysql_fetch_array or mysql_fetch_row on this resource, and then evaluating that result by for instance a while loop or so.

[Lars_Berg]

There is only one issue with select max(id). It should never be used.

use the mysql_insert_id() function instead.

http://www.php.net/manual/en/function.mysql-insert-id.php

[LoserBhoy]

thanks for you help guys.

LB