Date Format. yyyy/mm/dd to mm/dd. Better method?

[merlinti]

Hi All,

I'm new to php, so I know there must be an easier way to do this.
I am getting the DateFrom, and DateTo from a MySQL database as yyyy/mm/dd, but I want it to display as mm/dd.

I figured it out as shown below.
The output I get is: 5/13-5/22

It seems like a lot of code to do this.
Any ideas on making this shorter? A function?

Thanks for any help.

<?

include ("php1212/mysqstuff.php");

$Link = mysql_connect ($Host, $User, $Password);
$Tablename = "aladdin_bluenote";

// Shows DateFrom

	$Query = "SELECT DateFrom FROM $Tablename WHERE (Performer = 'Eric')";
	mysql_select_db($DBName) or die(mysql_error());
	$DateQuery = mysql_query ($Query) or die(mysql_error().'<br />'.$Query);
	while ($Row = mysql_fetch_array ($DateQuery)) {
	$OldDate = "$Row[DateFrom]";
	}

$OldDate01 = explode ("-" , $OldDate);

$NewDateMM = ("$OldDate01[1]");
$NewDateDD = ("$OldDate01[2]");

$NewDateMM01 = explode ("" , $NewDateMM);
$NewDateMM02 = ("$NewDateMM[0]");
$NewDateMM03 = ("$NewDateMM[1]");

	if ($NewDateMM02=="0") {
		print ("$NewDateMM03");
		print ("/$NewDateDD");
		print ("-");
		}else{


		print ("$NewDateMM02");
		print ("$NewDateMM03");
		print ("/$NewDateDD");
		print ("-");

	}

// Shows DateTo

	$Query = "SELECT DateTo FROM $Tablename WHERE (Performer = 'Eric')";
	mysql_select_db($DBName) or die(mysql_error());
	$DateQuery = mysql_query ($Query) or die(mysql_error().'<br />'.$Query);
	while ($Row = mysql_fetch_array ($DateQuery)) {
	$OldDate = "$Row[DateTo]";
	}

$OldDate01 = explode ("-" , $OldDate);

$NewDateMM = ("$OldDate01[1]");
$NewDateDD = ("$OldDate01[2]");

$NewDateMM01 = explode ("" , $NewDateMM);
$NewDateMM02 = ("$NewDateMM[0]");
$NewDateMM03 = ("$NewDateMM[1]");

	if ($NewDateMM02=="0") {
		print ("$NewDateMM03");
		print ("/$NewDateDD");
		}else{


		print ("$NewDateMM02");
		print ("$NewDateMM03");
		print ("/$NewDateDD");
	}

mysql_close ($Link);
?>

[vitch2002]

You can use the mysql date_format function:

$Query = "SELECT date_format(DateFrom, '%m/%d') as theDate FROM $Tablename WHERE (Performer = 'Eric')"; 

theDate is then a string ready for you to output.

more info here:

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

[hand]

<? 
include ("php1212/mysqstuff.php"); 

$Link = mysql_connect ($Host, $User, $Password); 
$Tablename = "aladdin_bluenote"; 

// Shows DateFrom 
$Query = "SELECT
			date_format(DateFrom,'%c/%e') as handFrom,
			date_format(DateTo,'%c/%e') as handTo
		FROM $Tablename
		WHERE (Performer = 'Eric')";

mysql_select_db($DBName) or die(mysql_error()); 
$DateQuery = mysql_query ($Query) or die(mysql_error().'<br />'.$Query); 

while ($Row = mysql_fetch_array ($DateQuery)) { 
	print $Row[handFrom]."-".$Row[handTo]; 
} 

mysql_close ($Link); 
?>

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

[merlinti]

Thanks Guys.

It works perfectly.

Thanks for the help😃