Many thanks Ray.
Over the weekend, someone suggested using TIMESTAMP, which worked until I tried to make it all dynamic, where it fell apart due to the ' '
Anyway, got is all working now by: (thee 'es_ES.UTF8' will be changed on the final page to a database value)
$query_rsTest = "SELECT pages.PgID, pages.PgTitle, UNIX_TIMESTAMP(pages.EvStDate) AS EvStDate, DATE_FORMAT(pages.EvStDate, '%H:%i') AS StTime, 'es_ES.UTF8' AS 'locsetting' FROM pages WHERE pages.EvStDate <>'' limit 5";
then
<?php do { ?>
<p> <?php
setlocale(LC_TIME, $row_rsTest['locsetting']);
echo strftime("%a %e %b %Y", $row_rsTest['EvStDate']);
?><?php /*START*/ if ($row_rsTest['StTime'] <>'00:00'){ ?> at <?php echo $row_rsTest['StTime']; ?><?php /*endT*/ } ?></p>
<?php } while ($row_rsTest = mysql_fetch_assoc($rsTest)); ?>
<?php
// reset the recordset after a repeat region
mysql_data_seek($rsTest, 0);
// get the first row from the recordset
$row_rsTest = mysql_fetch_assoc($rsTest);
?>
I've separated the time values and will have a translation field for 'at'.
Job sorted!
Many thanks once more,
Cheers
Chris
