webtuto Posted January 10, 2008 Share Posted January 10, 2008 hi i have in the column many numbers splited on rows so how can i make a sum of all these numbers and divied the result on the number of these numbers ? Link to comment Share on other sites More sharing options...
akitchin Posted January 10, 2008 Share Posted January 10, 2008 despite your question being worded very poorly, i'll point you to two functions that will likely get you on your way: COUNT() SUM() both in the mysql manual. Link to comment Share on other sites More sharing options...
webtuto Posted January 10, 2008 Author Share Posted January 10, 2008 t gives this error Database error: Unknown column 'rate' in 'field list' even if in the table "rate" there is a column named "rate" Link to comment Share on other sites More sharing options...
Barand Posted January 10, 2008 Share Posted January 10, 2008 Is this a guessing game? Post your code. Link to comment Share on other sites More sharing options...
Barand Posted January 10, 2008 Share Posted January 10, 2008 despite your question being worded very poorly, i'll point you to two functions that will likely get you on your way: COUNT() SUM() both in the mysql manual. Here's a third AVG() Link to comment Share on other sites More sharing options...
Barand Posted January 10, 2008 Share Posted January 10, 2008 Why am I wasting my time on you? DON'T double post again. Link to comment Share on other sites More sharing options...
Recommended Posts