Could some one give me an idea as to what I SQL query could use to get the percentages of each differant colomn value.
ie if this was my table: +-------+---+ | name | id | +-------+---+ | foobar | 1 | | foobar | 2 | | foobar | 3 | | barfoo | 4 | +-------+---+ I would get this result(Then later do stuff with it in PHP): +-------+--------+ | name | percent | +-------+--------+ | foobar | 75 | | barfoo | 25 | +-------+--------+ Thanks in advance, -- JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php