Get Largest INT from database

[wanted420]

Ok i have an ID autoincrement field and i want to be able to see what the id is. For ex:

id=0
id=1
id=2
id=3

i want it to show me 3 and not anything below it.

[YappyDog]

select max(id) from myTable

[wanted420]

Ok i am guessing there is a min(id) too. This is what i have:

$gid="SELECT min(id) FROM post";
$gid2=mysql_query($gid);
$gid3=mysql_fetch_array($gid2);
$l=$gid3['id'];

and i end up with the index 'id' undefined. Not sure why i get this error. it seems to work with normal varchar fields but maybe not int autoincrement fields?

[YappyDog]

You probably just need to add an alias for what you are selecting

$gid="SELECT min(id) as id FROM post";
$gid2=mysql_query($gid);
$gid3=mysql_fetch_array($gid2);
$l=$gid3['id'];

[wanted420]

Thanks for all you help 🙂 it works