![]() |
| |||||||
| Mysql Forum Mysql Forum |
![]() |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
| |||
| PHP/MySQL please help?
the query below does NOT sort date properly either by asc (the default) or desc: "select Title, date_format(Date, '%d %M, %Y') as Date from Table1 order by Date"; i wish to have things like: June 30, June 15, May 24 etc, to show latest articles first. what to do? zank you. fps_dean: thanks for input; the date is set in mySQL as 0000-00-00 (Year, month, day) and then i format it using the date_format function. My problem is with sorting, it does not show the latest articles first. |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| PHP / MySQL: MAXIMUM how many online users can a MySQL database handle if... | Shervin E | Mysql Forum | 0 | 08-30-2008 12:46 AM |
| To build database using Mysql what is the best tool: Mysql query broswer or | George | Mysql Forum | 1 | 05-18-2008 10:25 PM |
| where i have to place mysql driver in apache tomcat while connecting mysql | sunny | Mysql Forum | 0 | 01-12-2008 06:54 PM |
| MySQL/PHP problem. getting field names from MySQL and using it asPHP variables | Glenmore Vinoya | PHP Forum | 6 | 10-28-2003 04:28 PM |
| MySQL/PHP problem. getting field names from MySQL and using it asPHP variables | Glenmore Vinoya | PHP Forum | 0 | 10-27-2003 03:17 PM |