$mysql_date = "2004-06-14"; $display_date = format_date($mysql_date); echo $display_date;[/code] should do it nicely, though international users may wish to shuffle the order of the parts to suit the conventions in their part of the world ?
@aoeguyJun 15.2004 — #You could use a timestamp for it to be easier for people to change them.
The function would be [b]time()[/b]
When you insert it to the table, use
'INSERT INTO table (bla, time) VALUES ("text",'.time().')';
when you get it from the table, format it like this: [code=php] $format = $users_set_format_or_whatever; // Well it doesnt have to be $sql = 'SELECT * FROM table WHERE............'; $result = mysql_query($sql); $result = mysql_fetch_array($result);
@charterauthorJun 15.2004 — #[i]Originally posted by aoeguy [/i]
[B]You could use a timestamp for it to be easier for people to change them.
The function would be [b]time()[/b]
When you insert it to the table, use
'INSERT INTO table (bla, time) VALUES ("text",'.time().')';
when you get it from the table, format it like this:
[code=php] $format = $users_set_format_or_whatever; // Well it doesnt have to be $sql = 'SELECT * FROM table WHERE............'; $result = mysql_query($sql); $result = mysql_fetch_array($result);