More mySQL help

[Reality15]

Alright, so I was working on my website today, and noticed that the news articles were in a weird order, and realized a slight problem in my script that I don't know how to fix.

When I run my "add_news.php" script, it allows me to input a news story. It then gets the ID of the newest story, adds one to it, and saves it to the mySQL. The only problem is, when I added the first 8 articles I did it in phpMyAdmin as "001", "002", etc..., and when I ran the script for the first time, it made the ID "9".

How can I get it so that the numbers are in the same form as I started them in the mySQL? Is there a certain structure thing I need to do in phpMyAdmin or is there something I need to add to my ID + script?

Thanks,

~ Reality

[devinemke]

Originally posted by Reality15
...It then gets the ID of the newest story, adds one to it, and saves it to the mySQL...

don't do that. set the primary key field to "auto_increment" and let mySQL do the numbering for you.

[Reality15]

A bit late for that, I'm already using the "ID" field for many other things so I can't change that. Any other ideas of how to fix it?