hi, i have a simple date question, i’m new to using php and mysql and with the help of books and website have developed a little news feed, but the date is not showing how i want it to, currently its [COLOR=Red]“2004-06-21 16:37:12”[/COLOR] but i want to view it like [COLOR=Red]june 2004[/COLOR] below is the code i have used all help appericated.
<?php
$conn = mysql_connect('xxxxx', 'xxxxx', 'xxxxx')
or die(mysql_error());
mysql_select_db("xxxxxxxx", $conn) or die(mysql_error());
// create the SQL statement
$sql = "SELECT * FROM news ORDER BY news_create_time DESC";
// execute the SQL statement
$result = mysql_query($sql, $conn) or die(mysql_error());
//go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$news_title = $newArray['news_title'];
$news_text = $newArray['news_text'];
$news_create_time = $newArray['news_create_time'];
//echo the results onscreen
echo "<font color=\"#FF0000\" size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\">$news_title<br><br>$news_text<br><br>$news_create_time<br><br></font>";
}
?>