Displaying date in php
Posted: Thu Nov 16, 2006 6:43 am
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 >:(
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 >:(