Osman, try the follwoing (Substitutign your own variables)
list($Year,$Month,$Day) = split('-',$date_team); //Remove the '-' from
the MySQL sate format.
$stampeddate = mktime(12,0,0,$Month,$Day,$Year); //Create a UNIX style timestamp from
the result
$date_team = date("d M Y",$stampeddate); //Use php date function and args' to print in
more useable format
HTH :)
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
http://gertrude.sipu.anglia.ac.uk/webteam
[EMAIL PROTECTED]
+44 (0)1223 363271 ext 2331
www.theruss.com
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]