table update.

[ggp]

Hi. Could you help me?

I have being working with a database.
I created it using a php form. it display every thing propelly using a php page, then i use the DELETE statement to empty the table and then i start adding data again.
Then I did a SELECT * FROM table-name and it show everything fine but then I notice that the colum id/primary key does not start from the beginning gain so i did updated the table from the mysql command line fixing just the id columm with the righ id/primary key.

Now i do a SELECT * FROM table_name and it is updated fine, but when i run the php page that used to display everything, it does not show anything from the database.

Do i have to drop the table and start all over again?

Thanks

[laserlight]

Generally, let the autoincrementing primary key be. If you want to empty the table and start from scratch, use a DROP TABLE followed by a CREATE TABLE. This should reset the starting index of the primary key since it is a new table with the same schema.