[RESOLVED] Formatting with the date function

jamjam

I am trying to format a "datetime" field from a MySQL table with PHP date function.

Here is my code

<?php
if($row['time'] == ""){echo "Not Available";}
else {echo "<span class=\"time\"> date('g:i a', strtotime($row[time])); </span>";} 
?>

This works like I wanted when not used inside a if else statement.

Thanks for your help

bradgrafelman

You're trying to call the [man]date/man function yet you've simply placed the PHP code inside of a string. Instead, you want to concatenate the value of the date() function into that string. Basic example to show concatenation:

$myString = "Hello there, " . getName($thisUser) . " !";

Also note that MySQL can reformat a date string for you as well via the DATE_FORMAT() function.

anakadote

You need to separate out functions from what you're echoing:

<?php
if($row['time'] == ""){
   echo 'Not Available';
} else {
   echo '<span class="time">' . date('g:i a', strtotime($row['time'])) . '</span>';
}
?>

jamjam

After sometime tinkering, I fianally go it to work .

Thanks