Hi, > I want to make this sql query visual does anybody have > any idea :-) > SELECT date_format(t_timestamp_opened,'%Y %m %d'), > count(date_format(t_timestamp_opened,'%Y %m %d')) > FROM crm.ticket group by date_format(t_timestamp_opened, > '%Y %m %d') order by t_timestamp_opened;
Visual? What do you mean? You want to display the results on the page? In that case, just step through using mysql_fetch_array and echo each row. Or did you want something else? Cheers Jon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php