echo date

[bull]

i got field added in my db table

in one page i echo $row[added]
like .. 2006-08-17 13:51:38

and in other i need echo just date
like .. 2006-08-17

how it could be done?

[bradgrafelman]

Instead of selecting added, use the DATE() function:

SELECT DATE(`added`) as `date_added` FROM `myTable`;

Now, using $row['date_added'] would return just the date.