SQL counting

[Anon]

I have a question that is sooo basic that I can't seem to find the answer out there on the web. I need to do two tings in a table... one : every time I add an entry a new number be assigned like first entry is 1 second 2 one millionth is 1,000,000 and the other thing I want to do is make it so that every time that entry is updated in another feild 1 is added.... I know this should be really EZ and all the work is being done through PHP (I could just write a PHP workaround to the problem but if there is a right way to do it I'd prefer that)

[brandonschnell]

1) CREATE TABLE table_name (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, count INT DEFAULT 0, your_data TEXT)

ceate a table, when inserting leave off the id value and the next id will automatically be assigned (the 1st entry will be 1, the 2nd insert will be id 2, etc)

2)UPDATE TABLE table_name SET count = count+1, your_data = 'whatever';

when updating the table increment the count value by one.