$qr="select DATE_FORMAT(date_field,\"%Y-%d\") as fmt_date from table $whereclause";
then grab 'fmt_date' from the results... > Don´t really want to bother you with these quickies - but: > > If i have a result from mysql that is a date (2002-02-09) - how do i change > that into a variable with only the first 7 characters (2002-02)? > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php