Date doesn't display :(

[Genesis730]

Here is my code

 

anyone know why the date doesn't get outputted onto my page? everything else does

 

<?PHP
$res = mysql_query("SELECT id, DATE_FORMAT(`date`, '%S %D %Y'), firstname, lastname, testimonial FROM testimonials ORDER BY date DESC LIMIT 10");

while ($row = mysql_fetch_assoc($res)) {
    echo "<b>{$row['firstname']} {$row['lastname']}</b><br />on {$row['date']}<br />{$row['testimonial']}<br /><br />";
}
?>

[oni-kun]

What is displayed in your database table for 'date'?

[Genesis730]

i have 2 rows currently,

 

1 - 2009-09-29 06:25:38

2 -  2010-01-07 00:25:40

 

 

all that outputs is "on "

[topflight]

Also try:

 

echo "<b>{$row[firstname]} {$row[lastname]}</b><br />on {$row[date]}<br />{$row[testimonial]}<br /><br />";

 

instead of this:

 

  echo "<b>{$row['firstname']} {$row['lastname']}</b><br />on {$row['date']}<br />{$row['testimonial']}<br /><br />";

 

[PravinS]

Try this

<?PHP
$res = mysql_query("SELECT id, DATE_FORMAT(date, '%S %D %Y') as dt, firstname, lastname, testimonial FROM testimonials ORDER BY date DESC LIMIT 10");

while ($row = mysql_fetch_assoc($res)) {
	echo "<b>{$row['firstname']} {$row['lastname']}</b><br />on {$row['dt']}<br />{$row['testimonial']}<br /><br />";
}
?>

 

If "date" is you field name then it should work.

[Genesis730]

Right on pbs, thanks! Worked great =]