Date issue - not todays date!!

[lisar]

Hi All,
Ok so I am not sure whether this is the right place to post it, but here goes.

My Date is printing like this from the database: 2003-08-26
But I want it something like this 26th July, 2003

I have looked at echo date ("l dS of F Y"); but I cannot do the retrieve bit ($myrow4["date"]😉 and edit the format.

Date is obviously todays date as in NOW - but I want to edit a date from the database.
Can anyone please help me with the syntax to combine both the retrieved date and place it in a particular format aswell.
See my existing code at the moment.
All the best
Lisa

	<?
	$sql4 = "SELECT id, date, title, location, time FROM nac_fixtures";
	$result4=mysql_query($sql4);

while ($myrow4 = mysql_fetch_array($result4)) {

?>


<TABLE WIDTH=90% CELLPADDING=0 CELLSPACING=3 BORDER=0 BORDERCOLOR="#cccccc">

<TR>
<TD  CLASS="content" VALIGN=TOP>
<TABLE WIDTH=100% CELLPADDING=0 CELLSPACING=0 BORDER=0 BORDERCOLOR="#000040">
<TR><TD CLASS="content" VALIGN=TOP><?echo $myrow4["date"];?></TD>
<TD CLASS="content" VALIGN=TOP><?echo $myrow4["title"];?></TD>
<TD CLASS="content" VALIGN=TOP><?echo $myrow4["location"];?></TD>
<TD CLASS="content" VALIGN=TOP><?echo $myrow4["time"];?></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<?}?>

[OhLordy]

I find it easiest to store dates in the DB in timestamp form because it's quicker to search on and it's easier to manipulate either way with functions like mktime and date.
HTH
Rob

[seby]

i dont know why people don't store the timestamp using time()

it makes life so much easier...

[trooper]

<?php

$sql4 = "SELECT id, 
       DATE_FORMAT(date,'%W %D %M %Y') as 'date', 
title, location, time FROM nac_fixtures"; 
$result4=mysql_query($sql4); 

while ($myrow4 = mysql_fetch_array($result4)) { 

?>

the code DATE_FORMAT(date,'%W %D %M %Y') will return the date in the format that you want - of course i am assuming that you are storing the date in teh db in M-D-Y format 🙂

HTH

GM