Best method to changed numbered rows order....

I am attempting to post articles into the database of a Joomla install.

When I post in, everything goes into one table (article, title etc)

On another table it sets the order for the front page like this…

[table][tr]
[td]articleID1[/td][td] - [/td][td]position1[/td]
[/tr]
[tr]
[td]articleID2[/td][td] - [/td][td]position2[/td]
[/tr]
[tr]
[td]articleID3[/td][td] - [/td][td]position3[/td]
[/tr]
[/table]

So when I manually post into the database, what can i do to make this happen…

[table]
[tr]
[td]articleID4[/td][td] - [/td][td]position1[/td]
[/tr]
[tr]
[td]articleID1[/td][td] - [/td][td]position2[/td]
[/tr]
[tr]
[td]articleID2[/td][td] - [/td][td]position3[/td]
[/tr]
[/table]

And the next article posted in would do this…

[table]
[tr]
[td]articleID5[/td][td] - [/td][td]position1[/td]
[/tr]
[tr]
[td]articleID4[/td][td] - [/td][td]position2[/td]
[/tr]
[tr]
[td]articleID1[/td][td] - [/td][td]position3[/td]
[/tr]
[/table]

There will be way more articles on the front page btw… 3 in my example for simplicity…

Sponsor our Newsletter | Privacy Policy | Terms of Service