date formatting

[cherie]

I have read dozens of posts, manuals, etc on date formatting. I know exactly how I want my date to be formatted and all of the various options I have for formatting the date.

But where do I put the information?

My query is

//used for default display of tours by date
mysql_select_db($database_atours, $atours);
$query_tourDate = "SELECT * FROM tours, artists WHERE tours.artist_id=artists.artist_id AND date > NOW() ORDER BY date ASC";
$tourDate = mysql_query($query_tourDate, $atours);
$row_tourDate = mysql_fetch_assoc($tourDate);
$totalRows_tourDate = mysql_num_rows($tourDate);

The two dates I need to format are coded like this

<?php 
echo "<span class='tour-head'>"; 
echo $row_tourDate['date']; 
?>
 
<?php 
if(trim($row_tourDate['dateend']) != '0000-00-00'){ 
// print out everything 
echo " through "; echo $row_tourDate['dateend']; 
}else{ 
// don't do anything 
} 
?>

I want to include date('M, d, Y').
I have also tried this in my query DATE_FORMAT(date, '%d %m %Y')

Just not sure where to put the info.

Your help is appreciated.

[gimbles]

//used for default display of tours by date
mysql_select_db($database_atours, $atours);
$query_tourDate = "SELECT * FROM tours, artists WHERE tours.artist_id=artists.artist_id AND date > NOW() ORDER BY date ASC";
$tourDate = mysql_query($query_tourDate, $atours);
$totalRows_tourDate = mysql_num_rows($tourDate);
 
 
while($row_tourDate = mysql_fetch_assoc($tourDate)) {
 
 
 
    echo "<span class='tour-head'>"; 
    echo $row_tourDate['date']; 
 
    if(trim($row_tourDate['dateend']) != '0000-00-00'){ 
        // print out everything 
        echo " through "; echo $row_tourDate['dateend']; 
    }else{ 
        // don't do anything 
    } 
}
?>

Post all you code cause I dont fully understand your problem

[AlienDev]

Is dateend a unix timestamp or a MySQL date?

For unix timestamp:
echo date('M, d, Y', $row['dateend'];

For MySQL date field:
echo date('M, d, Y', strtotime($row['dateend']));
(I think)

Edit:

    if(trim($row_tourDate['dateend']) != '0000-00-00'){
        // print out everything
        echo " through "; echo $row_tourDate['dateend'];
    }else{
        // don't do anything
    } 

can be written as

    if(trim($row_tourDate['dateend']) != '0000-00-00'){
        // print out everything
        echo " through "; echo $row_tourDate['dateend'];
    } 

[cherie]

Thank You AlienDev. It nows works and I now understand how it works.

I am using dates pulled from the MySQL table. So echo date('M, d, Y', strtotime($row['dateend'])); works great.

[logic_earth]

Do the formatting within the SQL query itself:
http://dev.mysql.com/doc/refman/5.0/...on_date-format

DATE_FORMAT(date, '%d %m %Y') AS date

[felgall]

Formatting your output in the SQL before passing it back to the PHP is more efficient and uses less code.