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]

Reply via email to