MySQL Forums
Forum List  »  Newbie

avg(count( )) for last 4 months ?
Posted by: bhavani malladi
Date: October 21, 2012 07:04PM

hi
i have to find out avg(count) values with months for last 4 months
how i can do this


table stucture was
CREATE TABLE `lime_survey_16579` (
`id` int(11) NOT NULL auto_increment,
`submitdate` datetime default NULL,
`lastpage` int(11) default NULL,
`startlanguage` varchar(20) collate utf8_unicode_ci NOT NULL,
`token` varchar(36) collate utf8_unicode_ci default NULL,
`16579X10X31` varchar(5) collate utf8_unicode_ci default NULLPRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=480 ;





here $survey = lime_survey_16579
and $temp= 16579X10X31
here 16579X10X31 has values like A1 A2 A3 ..

how i can do this to give output like

avg month

2 july
4 aug
6 sep
9 oct


can anybody help me?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
avg(count( )) for last 4 months ?
October 21, 2012 07:04PM


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.