Jump to content

pulling information and split


jacko_162

Recommended Posts

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...

Link to comment
https://forums.phpfreaks.com/topic/197784-pulling-information-and-split/
Share on other sites

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.