How to get id after insert data

[eluser]TheFuzzy0ne[/eluser]
To elaborate further on Yorick's comment, this would cause a race condition where simultaneous requests would both calculate the same ID, and cause an error when inserted. Because of this, it's best to use an auto incremented field, and grab the ID once the row has been inserted.