badeand Posted March 17, 2011 Share Posted March 17, 2011 Hi, I'm trying to get out the average of records stored in a mysql table This is the code im using right now mysql_query("SELECT DATE(dato) , COUNT( dato ) AS counted FROM dekodere GROUP BY date(dato)", $link); $ave = mysql_num_rows($ave); This is getting out the average, but i need to exclude weekends because there is not stored anything during the weekend so it's making the average go off.. any tips? Link to comment https://forums.phpfreaks.com/topic/230879-problem-counting-average-row-for-each-day/ Share on other sites More sharing options...
nicholasolsen Posted March 17, 2011 Share Posted March 17, 2011 List more information about the tables your using.. This line of code doesnt tell me a lot of whats going on. In norwegian: Legg ut informasjon om hvordan sql tabellene ser ut. Vanskelig å skjønne noe ut i fra hva du nevnte. Hvis du ikke finner svar kan du sende meg en PM så skal jeg gjøre mitt beste. Link to comment https://forums.phpfreaks.com/topic/230879-problem-counting-average-row-for-each-day/#findComment-1188515 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.