Re: [PHP] ADV SQL Help Needed.

SELECT risk_level, COUNT(*) FROM mytable GROUP BY risk_level; - Original Message - From: "[-^-!-%-" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 6:06 AM Subject: [PHP] ADV SQL Help Needed. Hello everyone, I need help with the following query. I have a t

Re: [PHP] ADV SQL Help Needed.

This sample also work in PhpMyAdmin, but not from the php code. Please advise. **see previous post, for sample code** Thanks Rick. -john =P e p i e D e s i g n s www.pepiedesigns.com Providing Solutions That Increase Productivity Web Developement. Database. Hosting. Multimedia. On

Re: [PHP] ADV SQL Help Needed.

off the top of my head SELECT risk_level, COUNT(risk_level) AS rl_count GROUP BY risk_level should do it, though I'd have to experiment with what's inside the COUNT(). Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] - Original Message - From: [-^-!-%- <[EMAIL PROTECTED]> To: <[EM