using variable instead of 'date' (M-D-y)

Sulphy

Hi peeps 😃

Heres the problem i've got.

Using a query I obtain a date that has been input by a user, the input is short date format e.g. 2002-05-12

What i want to do is to be able to use that variable and display it as 12 May 2002. Is there anyway of setting the value of the 'DATE' function. I want to be able to play around with the formatting of the dates like u can using 'echo date(D-M-y)' but using 'echo $variable(D-M-y)'

Thanks in advance 🙂

Pete:p

mrmufin

Assuming your using MySQL, you can just use the DATE_FORMAT() function in your query:

$query = "SELECT DATE_FORMAT(date_column, \"d M Y\") AS \"Date\" FROM table"

Sulphy

Soz, still having probs with it, i'm very new to PHP :p

I am using mySQL and i've amended the string you quoted to

$query = mysql_query("SELECT DATE_FORMAT(edate, \"d M Y\") AS \"Date\" FROM events");

I'm not getting anything when i try to access the array using

while ($row = mysql_fetch_array($query)) {
echo( "EVENT: " . $row["edate"] . " ");
}

The query i want to use is

$result = mysql_query("SELECT event, descrip, edate, status, id FROM events WHERE status = 'Active' GROUP BY edate LIMIT 2");

but with the DATE_FORMAT statement included, can that be done??

The existing code i'm using to get the data out of the array is

if (!$result) {
echo( "Error connecting to database");
exit();
}
while ($row = mysql_fetch_array($result)) {
echo( "EVENT: " .
$row["event"] .

"<br><B>DESCRIPTION: </b>" . 
$row["descrip"] .

"<br><b>EVENT DATE: </b>" .
$row["edate"] . "<br><br>");

}

Soz, its really simple i know, just havin writers block 😃

Pete

mrmufin

I'm sorry. I screwed up. When using the DATE_FORMAT() function in MySQL, there needs to be a % prior to each date formatting variable:

$query = "SELECT event, descrip, status, id DATE_FORMAT(edate, \"%d %M %Y\") AS 'edate' FROM events WHERE staus='Active' GROUP BY edate LIMIT 2";

// Run the query:
$result = mysql_query($query);

// Test the result ID:
if(!$result) {
	// If the query didn't get a result set, find out why:
	echo 'Query ' . $query . ' failed.' . mysql_error();
} else {
	// process the result set data:
	while($row = mysql_fecth_array($result, MYSQL_ASSOC)) {
		echo '<b>EVENT: </b>' . $row['event'];
		echo '<b>DESCRIPTION:</b>' . $row['descrip'];
		echo '<b>DATE:</b>' . $row['edate'];
	}	
}

Any better? Sorry about the confusion...

Sulphy

It worked perfectly 😃

Thank you so much!!!