...

View Full Version : Date display in php



aniltc
11-16-2006, 02:00 PM
hi all


I am new to php. I have a problem in my site.I have a news and Events section in my home page,in which i want to display the latest news and events based on current server date.I am storing entire date in the database.

database structure

Input to Mysql database

DATE(dd-mm-yyyy) News and EVENTS
8-10-2005 XXXXXXXXXX
8-10-2006 XXXXXXXXXX
1-11-2006 XXXXXXXXXX
14-11-2006 XXXXXXXXXX
16-11-2006 XXXXXXXXXX
18-11-2006 XXXXXXXXXX
30-12-2006 XXXXXXXXXX

#########################################################
I need the o/p in the following format(consider 16-11-2006 is the current Server date)

DATE(dd-mm-yyyy) News and EVENTS
16-11-2006 XXXXXXXXXX
18-11-2006 XXXXXXXXXX
30-12-2006 XXXXXXXXXX
14-11-2006 XXXXXXXXXX
01-11-2006 XXXXXXXXXX
8-10-2006 XXXXXXXXXX
8-10-2005 XXXXXXXXXX



please help me the logic or providing the code >:(

SeeIT Solutions
11-16-2006, 02:07 PM
You should store dates in a database using a timestamp in an integer field, then print that out using the date() (http://php.net/date) function.

To generate a timestamp, use time() (http://php.net/time), strtotime() (http://php.net/strtotime) or in SQL use UNIX_TIMESTAMP().

You can convert your current dates using http://www.onlineconversion.com/unix_time.htm



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum