sorry, I read your post wrong!
don't use php functions, but use native database functions. in mysql you can use date_format() SELECT field from table where date=DATE_FORMAT(now(), '%d/%m/%y); this makes the format of now(), which is 2002-12-07 into a format with first the days of the week in numeric form (%d) followed by a / (/) followed by the months of the year in numeric form(%m) etc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php