adding count from 1 to 500 in existing table field - field is currently empty

[Giddy Rob]

Hey,

 

I am dealing with a table that has about 500 records. My problem is that I need to create an index and auto fill it from 1-500 (not manually). Once this is done I would like the table to autoincrement when a new record is added.

 

I have set up a field called 'item_number', which is the index field.

 

What php/mysql code do i need to run to fill the table from 1 (first record) to 500 (last record)? I'm hoping I can convert it to an index and autoincrement in phpmyadmin once this is done. At the moment if I try this I just get an error, duplicate field.

 

Cheers

 

Rob

[Giddy Rob]

BTW, the table is full of information so I dont just want to create a new table