Format date on page when taken out of MYSQL database 1

[jewel464g]

When I pull the data out of my database. The date shows exactly like it is in the database. How can I get it to format in the standard DD/MM/YYYY.

This is what my output looks like.

Start Date End Date Event Name
2002-11-28 2002-11-29 Happy Thanksgiving.


This is my code.

//connect to database and open it
$db = mysql_connect("localhost", "root"
mysql_select_db("cadb",$db);
$tableName = "calendarElem";
$pageName = "elem_calendar.php";
mysql_query(&quot;DELETE from calendarElem where endDate <= curdate()&quot;
$result = mysql_query(&quot;SELECT * FROM calendarElem ORDER BY startDate&quot;,$db);
echo &quot;<table border=0 cellpadding=5 cellspacing=0><tr><td><b>Start Date</b></td><td><b>End Date</b></td><td><b>Event Name</b></td></tr>&quot;;
if ($myrow = mysql_fetch_array($result)) {
do {
printf(&quot;<tr><td><b>%s</b></td><td><b>%s</b></td><td>%s</td></tr>&quot;, $myrow[&quot;startDate&quot;], $myrow[&quot;endDate&quot;], $myrow[&quot;description&quot;] );
} while ($myrow = mysql_fetch_array($result));
}
echo &quot;</table>&quot;;

http://www.scriptchick.com/

When faced with a decision, always ask, 'Which would be the most fun?'

 

[sleipnir214]

Try:
printf(&quot;<tr><td><b>%s</b></td><td><b>%s</b></td><td>%s</td></tr>&quot;, date(&quot;d/m/Y&quot;, strtotime($myrow[&quot;startDate&quot;])), date(&quot;d/m/Y&quot;, strtotime($myrow[&quot;endDate&quot;])), $myrow[&quot;description&quot;] );

For more information:

date():

http://www.php.net/manual/en/function.date.php

strtotime():

http://www.php.net/manual/en/function.strtotime.php

______________________________________________________________________
TANSTAAFL!

 

[KarveR]

whatever happened to SELECTing a date_formatted date from mysql during the query .../boggle

SELECT DATE_FORMAT('2002-11-20', '%D/%m/%Y');
-> 20/11/2002

substitute the date show for the name of your date field and hey presto ...

SELECT some,stuff,other,stuff,DATE_FORMAT(your_date_field, '%D/%m/%Y') from your_database WHERE otherstuff;
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[KarveR]

oh, heres tha manual page for full info :

http://www.mysql.com/doc/en/Date_and_time_functions.html

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.