View Full Version : data update column

06-28-2006, 04:18 PM
Hi guys.

I've been coming to the site for some time now (I enjoyed the VTMs, especially the ones that are now gone).

I'm making my site and have a question (well actually quite a few questions) regarding making an extra column in a php/mysql database

Here is the page on which the data appears in a table.



I want to generate another column which will be a 'Date Updated' collumn in which will appear the date that I upload new data (which will be every day).

My other idea is to make a pull down collumn which will allow the data to appear in a table by *daily *weekly *monthly

(hope that is clear)

any ideas?
thanks in advance

07-05-2006, 02:37 PM
ALTER TABLE mytable ADD date_updated DATE AFTER monthly;

mytable = name of table you wish to add column

date_updated = name for column

monthly = where you want the the new column to appear in the table structure