CMS (PHP/MySQL) question

[Bryan_T]

Hi,

I've made a pretty basic (crude, perhaps) content manager.
It enables the user to enter text into two fields, for date
and event information, which then get stored in a new db row.

Also, beneath the entry form, you get an ordered display of
existing entries, and beneath each one is a link to edit or
delete that particular entry. The public page then displays all the entries.
It is simple, but it does definitely work.🆒

My question is, there may be a better way. In order to identify each
entry for editing or deletion, the table has a field defined as Integer,
set to auto increment. So every time a row (new entry) is added,
that field in the new row has a unique number, which is used as an
identifying variable for the edit and delete functions.

This works fine, but it seems a little obtuse.
Is there a more elegant method of uniquely id'ing the entries?

Sorry if this is a MySQL question; I figured maybe someone
here might have a better idea.

Thanks.

[sid]

i think thats about the most elegant way you can do it... another way would be a timestamp as key, but then you could run into problems if 2 entries are submitted virtually simultaneously.

[Bryan_T]

Good, thanks for the input.