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 >:(
Displaying date in php
Moderator: General Moderators
Code: Select all
(
SELECT
...
WHERE
datefield=Curdate()
)
UNION
(
SELECT
...
WHERE
datefield!=Curdate()
ORDER BY
datefield DESC
)edit: forgot parentheses
Last edited by volka on Thu Nov 16, 2006 9:53 am, edited 2 times in total.
date display in php
hi
thanks for ur reply
let me check it and come back soon

thanks for ur reply
let me check it and come back soon