Eh, he's off topic, but we've talked plenty SQL on here before... SELECT num, COUNT( num ) FROM table GROUP BY num; I don't have a myqsl server to test that, but should do it. -- -Dan Joseph www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo Code "NEWTHINGS" for 10% off initial order http://www.facebook.com/canishosting http://www.facebook.com/originalpoetry
