Page 1 of 1

Displaying date in php

Posted: Thu Nov 16, 2006 6:43 am
by aniltc
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 >:(

Posted: Thu Nov 16, 2006 7:02 am
by feyd
Are you using a native DATE(TIME) field or a string type? Your post would suggest a string type, which in the format you've chosen more annoying to sort. If it were a DATE(TIME) type, all you'd require is an ORDER BY clause in your query, and probably a LIMIT clause too.

Posted: Thu Nov 16, 2006 7:29 am
by aniltc
hi

Thanks for ur reply

I am not looking for ascending or descending order.if the cuurent server date matches with any of the news and events which i have mentioned ,then that particular date should dispaly first otherwise it should display the latest date; please help me

Posted: Thu Nov 16, 2006 8:00 am
by volka

Code: Select all

(
	SELECT
		...
	WHERE
		datefield=Curdate()
)
UNION
(
	SELECT
		...
	WHERE
		datefield!=Curdate()
	ORDER BY
		datefield DESC
)
Curdate() is mysql specific, you may have to replace it.

edit: forgot parentheses

date display in php

Posted: Thu Nov 16, 2006 8:03 am
by aniltc
hi

thanks for ur reply

let me check it and come back soon


:)