pulling information and split

[jacko_162]

i have a date stored in mysql database but unfortunatly its not stored in date format as per phpmyadmin.

 

its a VARCHAR and displays like: April 1, 2010

 

is there anyway i can query the database and pull down the $date value and instead of echoing "April 1, 2010" i can split it to echo the month?? and a seperate query to echo the day??

 

pretty silly of me not reading up on the date thing though and now i have a bucket load of users who i cant change the date field...

[budlust]

you might want to look at this http://php.net/manual/en/function.explode.php

[jacko_162]

Very usefull

 

i used the explode function and i managed to split $date by doing:

 

<?php
$splitdate = explode(" ", "  $date  ");
echo $splitdate[3]; // prints "Day";
echo "<br>"; // prints space;
echo $splitdate[2]; // prints "Month";
?>

 

only problem i get now is that it echos this: "April 6," i dont want it to echo the ","

 

this is what i get when i echo the $date "April 6, 2010"

 

can anyone help me a little further?

[jcbones]

Try something like this:

 

<?php
$splitdate = explode(" ",trim($date));
echo str_replace(',','',$splitdate[1]); // prints "Day";
echo "<br />"; // prints space;
echo $splitdate[0]; // prints "Month";
?>

[jacko_162]

thank you