[PHP-DB] Date Concat?

[Rankin, Randy]

I have two fields of type date in a MySQL table called training:
    
    start_date
    end_date
 
I can format the date using a select, for example
    
    SELECT 
    DATE_FORMAT(start_date, '%M %d, %Y') as start_date,
    DATE_FORMAT(end_date, '%M %d, %Y') as end_date
    FROM training
 
This produces the following:
    
    start_date: September 16, 2002
    end_date: Sepetember 20, 2001
 
Based on the above, I would like to echo out something like this:
 
    You will be in training September 16 - 20, 2002.
 
Is this possible? 
 
Thanks,
 
Randy Rankin

Advertising

-------------------------------------------
Randy Rankin, MCSE
Network Management Professional
IBM Global Services
[EMAIL PROTECTED]
Phone:(870) 773-5148
Fax:  (870) 773-5211