Date Conversions

[Cheez]

Hello all,

I'm working on a website for my grandmother's quilting business, and I can't figure out how to change the date format to what she wants.

Right now, the following script pulls out the next three events from my SQL table and then displays them as: Datetime - Event Name (of course, with the appropriate information). Everything works GREAT on it, but she doesn't like the date format. She wants it to display the month and date only (i.e. July 22). How do I convert my current datetime format (normal mySQL datetime format) to the month and date?

Here is my script:

<?php
$currentdate = date('Y-m-d H:i:u');

$result = mysql_query("SELECT * FROM `classes` WHERE `datetime` >= '$currentdate' ORDER BY `datetime` ASC LIMIT 0 , 3"); 
while ($array = mysql_fetch_array($result)) 
{ 
    $datetime = $array['datetime']; 
    $name = $array['name'];  

echo "<b>$datetime -</b><i>$name</i><br>";  
}
?> 

Thanks in advance for any help!

~ Cheez

[hagen00]

$formatted_date = date("F j",$datetime );

It's all in the manual!http://www.php.net/date

[Installer]

That won't work, since the second argument to "date()" must be a Unix timestamp (it's in the manual).

This should do what you want, and a little more concisely:

$result = mysql_query("SELECT name, DATE_FORMAT(datetime, '%m %e') AS f_date " .
                      "FROM classes WHERE datetime >= NOW() ORDER BY datetime ASC LIMIT 0, 3");
while ($array = mysql_fetch_array($result)) 
{ 
    echo '<b>' . $array['f_date'] . ' - </b><i>' . $array['name'] . '</i><br>';   

}