MySQL Forums
Forum List  »  PHP

Help me i am struck
Posted by: hellobhaskar
Date: January 17, 2006 05:52AM

we have a table with the following fields how_know and created_Date

the how_know field contains air baloon,paper ads, banner ads,etc., as values
and created_date contains the date created with time

we need to create summery report like the below format for week

day1 day2 ......... day7
air baloon 2 1 4
paper ads 0 3 6
banner ads 2 0 4
.... 1 .....
..... ...
.... ...

Options: ReplyQuote


Subject
Written By
Posted
Help me i am struck
January 17, 2006 05:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.