Multiple Date format queries.

[Sonic_Rage]

I would like to format 2 different cells with the same type of date format, here is what I have done to get one to work, but not sure how to format a second one.

   $conn = db_connect();
   $query = "SELECT *, DATE_FORMAT(date, '%m/%d/%Y') AS thedate from minutes where id='$id'";
   $result = @mysql_query($query);

Would like to also format "last_modified" to show date like the actual date field shows.

Btw, I have my dates entered like this in MySQL yyyy-mm-dd

[cgraz]

Have you tried

SELECT *, DATE_FORMAT(date, '%m/%d/%Y') AS thedate,
   DATE_FORMAT(last_modified, '%m/%d/%Y') AS lastmodified 
FROM minutes 
   WHERE id='$id'

Cgraz

[Sonic_Rage]

Ok, so I can do it twice. I wasn't sure. It didn't seem to work for me, probably something I did. Thanks.