Formatting a date from a String. 1

[Plogu101]

Hi, a little date format problem: $result2 returns a String date from MySQL in the form 2005-03-23, and it is inserted in to a table. I just want to take that String and date format it into a day of the week 'Wed' for example, and insert that instead? Any help would be appreciated, thanks..

 while ($row = @ mysql_fetch_row($result2))
        {
     		echo "<td bgcolor='red'                  colspan='4'>".$row[0]."</td>";
        }

 

[spookie]

Have a look at DATE_FORMAT(date,format) MySQL function

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[Plogu101]

Cheers nice one spookie