How to make article number to display as a 3 digit number

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 10, 2009   (RSS)

By drewh01 - December 10, 2009

To conform to Google News standards, how can I get the article numbers from 1-99 display as a 3 digit number like this - 001 to 099? When the articles reach 100, I will not need the 00 do show. Google news requires that the URL for each article must contain a unique number consisting of at least three digits.

Currently, the articles began as "1"

http://65.99.232.147/articlesDetail.php?Is-Alcoholics-Anonymous-Effective-1

I need to to show as "001"

http://65.99.232.147/articlesDetail.php?Is-Alcoholics-Anonymous-Effective-001

Re: [drewh01] How to make article number to display as a 3 digit number

By Dave - December 10, 2009

Hi drewh01,

If you install the free MySQL Console plugin you can update your table so all new record numbers start at 100.

Would that work? See this post:
http://www.interactivetools.com/forum/gforum.cgi?post=75890#75890
Dave Edis - Senior Developer
interactivetools.com