PDA

View Full Version : data update column


mrclark0
06-28-2006, 05: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.

http://www.psre.net/foreclosures.php

http://www.psre.net/images/datapage.gif

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

davidj
07-05-2006, 03: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