Noob Question - Displaying Highest ID in a table

[kiksy]

Hi there,

 

Im guessing im missing something obvious and making this hard for myself....

 

Running : 5.0.81-community

 

$result = 'Select ID FROM comments HAVING MAX(id) > 1';
$row =  mysql_query($result);

echo $row['0'];

 

Table structure is ID as primary, then USERNAME , COMMENT, DATE, VALIDATED

 

 

All im trying to do is select the highest ID and then echo it , Ive searched around and found a few solutions but none seemed to work. All I want is the ID number as a $ .

 

Any help at all appreciated.

 

Thanks in advance.

[ejaboneta]

<?php 


$sql= 'Select MAX(id) FROM table';
$query =  mysql_query($sql);
$fetch = mysql_fetch_row($query );

echo $fetch['0'];

?>

[kiksy]

ahhhh!

 

Thanks so much! Kicking myself now!

 

Thanks again, hope I can help you some other day.