[eluser]BoyBlue[/eluser]
I've been looking for this answer for a little while and I'm sort of stumped...
I'm grabbing data (date and rating of a movie) from a mysql table to display on an HTML page. The way it has been input into the database is... Date: "date type' in mysql (1995-06-30)
Rating: 'g', 'pg', 'pg13', or 'r'
I want the HTML page to display them as (date) '1995' and (rating) 'G' or 'PG' or 'PG13' or 'R'
What would be the easiest way to accomplish this
without changing how the data is inserted into the table?
thanks,
Ryan