Even if this isn´t a mysql forum i hope to get some help on this: I have a table with 5 columns (named one to five) which contains numerical values between 1 and 10. I am trying to construct a query that gives me the count of the representation of each numerical value (ie how many fives that are stored).
Can i do this in a smart way without having to write fifty queries and add every fifth of them up? Regards # Daniel Alsén | www.mindbash.com # # [EMAIL PROTECTED] | +46 704 86 14 92 # # ICQ: 63006462 | +46 8 694 82 22 # # PGP: http://www.mindbash.com/pgp/ # -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]