I have an html/php form that updates entries on the database server. I need to add a field to each row indicating when that entry is added, so in other words a timestamp of when the entry was created. I have been searching and found this:
Would I do something like:
$timestamp = time(); mysql_query("ALTER TABLE notification ADD timestamp CHAR(30) AFTER names); mysql_query("INSERT INTO notification (`timestamp`) values ('$timestamp');
Any information would be helpful, thanks!
Provided information as requested:
So far I have:
mysql_query("INSERT INTO notification (`program`, `month`, `day`, `year`, `sponsor`, `type`, `category`, `range`, `desc`) values ('$pName' , '$month' , '$day' , '$year' , '$sponsor' , '$type' , '$category' , '$range' , '$desc')");