return value of mysql_query("select max(foo) from bar ?

[SUnruh]

i have the following:

$crud = mysql_query("select max(foo) from bar",$DatabaseLink);
settype($crud,"integer");
$gack = $crud+1;

$gack does not become 2 or larger, ever. not even after many inserts. it is always the same as $crud. which really hoses up the db.

i want the maximum value from column foo in table bar. then increment it for my next db insert.

what am i doing wrong/ideas?

rh7.3/mysql3.23.58/php4.1.2 (i think this is correct)

[Kudose]

//formulate the SQL
$sql = "SELECT MAX(foo) FROM bar";
//make the query
$query = mysql_query($sql);

//get the query result
(int)$max_id = mysql_result($query, 0);

//print it
echo $max_id;

[SUnruh]

once i incremented it, it works!

thanks much!!!