select count(FavNum) as Favorite where FavNum = 2; On Fri January 30 2004 8:19 pm, js wrote: > p.s.- im using PHP with MySQL... if that helps any. thanks > i want to know what i can use to count the number of times a value appears > in a column listing where different values are listed. for example, say in > the column of Favorite Number we have 100 students, and for each student > his or her own row. and each student can pick a number from 1-10. So, we > have a column of 100 rows and each field can contain either 1-10. Now, i > want to know how can i count the number of times lets say the #2 appears > in this list and give that count a number. so if #2 appears 43 times in > that column, then i want it to say "2 is listed 43 times." how do i do > this? thank you for your help with my beginner newbie questions. -james -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
