showing the date of a post

pk698

I have a form on my site where a user enters an ad and the ad is stored into a DB. when printing the ad, how do i make the date show up? the date of the ad when it was submitted, not the current date.

thnx.

LordShryku

record the date when you record the ad. Then just pull it with the ad

Thora_Fan

to expand on what LordShryku said...

a db table that you might want to consider would have fields for the ad information, and a TIMESTAMP field for the date. With MySQL, if you have a TIMESTAMP field set to NOT NULL, you don't need to include it into your INSERT statement, it will automatically add it for you.

Check out
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME

and
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions

For more information on using TIMESTAMP and the related Date/Time functions. Of course, if you are using something other than MySQL, you'll have to check that DB's docs for related field types/functions.

dhirendrak

Use timestamp as suggested in earlier post.
Your script may be:

$ad_time=time();

Store this $ad_time value in database during posting of ad.

And fetch it from database when required like;

$fetch_time=<fetched timestap from databse>;

And u can use php date function to display the posted date:

echo date("d / m / Y H : i : s",$fetch_time);

If you face any problem then pls let me know.

Thanks

pk698

ok, i deleted my old table and made a new one and made sure to put the TIMESTAMP field set to NOT NULL, but i got an error. see below. any ideas?

$TableName = "ads";

$Link = mysql_connect ($Host, $User, $Password);

$Query = "CREATE table $TableName (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, title TEXT, category TEXT, ad_descriptions TEXT, ad_closed TEXT, ad_price TEXT, TIMESTAMP NOT NULL, zip TEXT, campus TEXT)";

dhirendrak

A little change in your present query

$Query = "CREATE table $TableName (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, title TEXT, category TEXT, ad_descriptions TEXT, ad_closed TEXT, ad_price TEXT, posted_On INT(20), zip TEXT, campus TEXT)";

Try this query it will work.

and if you want to customize more your timestamp and date.

Than see date() and mktime() from php manual.

If face any problem pls let me know.
Thanks

pk698

yeah, the query worked and my tables were created, but when i submitted some data through a form, there's not date shown. i'll just keep trying....