[Deansatch]

I am trying to display the date in the "l dS F Y" format on my web page for each entry in the database. I have found plenty of articles on how to change the format for todays date but not for the actual date entered in a field.

my database field is named date and is of type "date". the entered date is 0000-00-00 format. This is the code I am using to try and convert it for display on the web page:

PHP Code:

$connection = mysql_connect($host,$usr,$pwd);

if ($date) { $date_sql = "and date LIKE '%$date%' "; }

if ($venue) { $venue_sql = "and venue LIKE '%$venue%' "; }



$query = mysql_db_query($db, "SELECT * FROM table_gigs where id > 0 $date_sql $venue_sql order by date desc", $connection);

check_mysql($query);

$filename = "list_header.html"; 

$handle = fopen ($filename, "r"); 

$contents = fread ($handle, filesize ($filename));

$contents = str_replace(XrowsX, mysql_num_rows($query), $contents);

print $contents;

fclose ($handle);





while ($row = mysql_fetch_array($query)) {

$date = $row["date"];

$date = date("l dS F Y", $date);  /* the bit in question */



$venue = $row["venue"];

$id = $row["id"];





$filename = "list.html"; 

$handle = fopen ($filename, "r"); 

$contents = fread ($handle, filesize ($filename));

$contents = str_replace(Xgigs_titleX, $gigs_title, $contents);

$contents = str_replace(Xheading_gigsX, $heading_gigs, $contents);

$contents = str_replace(XdateX, $date, $contents);

$contents = str_replace(XvenueX, $venue, $contents);

$contents = str_replace(Xbutton1X, $button1, $contents);

$contents = str_replace(Xbutton2X, $button2, $contents);

$contents = str_replace(Xbutton3X, $button3, $contents);

$contents = str_replace(Xbutton4X, $button4, $contents);

$contents = str_replace(Xbutton5X, $button5, $contents);

$contents = str_replace(XidX, $id, $contents);

print $contents;

fclose ($handle);

} 

any ideas?

[Nico]

Try this.

PHP Code:

$date = date("l dS F Y", strtotime($date) );  /* the bit in question */ 

[Deansatch]

The simple things! Genius once again. Thanks nico

[amkma]

And what if the date field is empty. I mean 0000-00-00.

With the above solution it shows 30/11/1999 for me.

Any help please.

[Jay6390]

Well, I tried the following

PHP Code:

$date = "0000-00-00";
echo date("l dS F Y", strtotime($date) ); 

and as expected, I got the Unix epoch date

Code:

Thursday 01st January 1970

Even with the string set to nothing, I got the same result. How you came to get 30/11/1999 I'll never know. Very random

[amkma]

Can we get the result as 00/00/0000 instead?

[Jay6390]

Originally Posted by amkma

Can we get the result as 00/00/0000 instead?

Not using strtotime no, as it returns a unix time, so 0 will be 1/1/1970, as that is the start of the Unix epoch

[amkma]

any alternative?
Or instead of 00/00/0000 can we get a blank result?

Regards

[Jay6390]

Originally Posted by amkma

any alternative?
Or instead of 00/00/0000 can we get a blank result?

Regards

not if you use the strtotime function no. you will have to test for it seperately beforehand

[UnrealEd]

there's a very simple workaround: you just use an if!