finding record with the highest ID
hot mornig people!
since yesterday i trie to find a solzution for my problem:
i am searching for a posibility to find the record with the highest id
i have a couple of records for displaying members of my community.the position in the list is definied by the variable POSITION. if i want to add a member i need to find the last member or the highest position id to init the new record with (highest position value+1)
but i dont know the query for finding the record with the highest position value. reading the select syntax @ mysql.com has not helped me.
anyone has a glue?