another painfully simple question (MySQL data)

can I blame it on monday?

[Sarah Atkinson]

I can not belive I am asking this but...

How do you alter the order your colums are in in the DB. I forgot to put my ID in at the begining and It's just easier to look at with it up there.

I think my productivity today is at an alltime low.
I even had to look up how to escape special charicters, the date() function, and how to write for() statements.

It's like everyting I know aboult mySQL and PHP decided to take the day off. I even made myself look like a fool infront of one of our directors.
Sarah

[arran]

This should do the trick:

ALTER TABLE <table name> MODIFY COLUMN <column name> <data type> FIRST