I am moving over from ASP to PHP and I am having a few teething troubles. I have a date field (currently a timestamp) in my mysql database and would like to show it on my php page as following example shows 23rd April 2009. However I would like to be able to make the rd part of the date a subscript (well I am actually going to use css to format it but for arguement sake a subscript). What would be the best way to go about this?

Decker

There's a few ways of doing this in php but since you're mentioning that you're calling this from a Mysql Database in your query just simply add this

date_format(fieldname,'%d%S %F %Y') as `fieldname`

just replace fieldname with the fieldname being used in your table.

In php it would become like:

<?php echo date('jS F Y'); ?>