Page 1 of 1
is there a way to check what is the most right column in mys
Posted: Sun Dec 21, 2003 5:46 am
by pelegk2
is there a way to check what is the most right column in mysql? what its name?
Posted: Sun Dec 21, 2003 6:56 am
by aquila125
Why do you need that?
It's not good practice to build your script around the place of a certain column.. if you ever want to add an extra column you'll need to change the entire script...
Posted: Sun Dec 21, 2003 7:22 am
by pelegk2
nope!
beacuse i every month add a new colimn on the right!
and beacuse of that i need to know what is the most right column!
by the way : is there a col limit?
Posted: Sun Dec 21, 2003 4:14 pm
by Hurklefish
I am very intrigued by your database schema.. could you post a little bit about the how and why of a monthly column addition? we might be able to set you up with something much better.
Posted: Mon Dec 22, 2003 12:31 am
by pelegk2
i want every new month to add dynamiclly
a col on the right
for example next month i want to add :
01_2004
which its meanning is obvious
and the user can update that month data for each row
Posted: Mon Dec 22, 2003 12:36 pm
by hedge
sounds like you have a serious design issue with your DB. New data should be in Rows, once your table structure is defined it should be static, unless funcionality is changed.
Posted: Mon Dec 22, 2003 5:25 pm
by d3ad1ysp0rk
couldnt you just call on the current month using date()??