RE: [PHP] records in db

2002-08-11 Thread Chris Kay
]] Sent: Sunday, 11 August 2002 12:09 PM To: Tyler Durdin; [EMAIL PROTECTED] Subject: Re: [PHP] records in db on 11/08/02 3:52 AM, Tyler Durdin ([EMAIL PROTECTED]) wrote: If I have a field in my DB that can have 4 different answers, lets say a,b,c and d. How can I count the number

[PHP] records in db

2002-08-10 Thread Tyler Durdin
If I have a field in my DB that can have 4 different answers, lets say a,b,c and d. How can I count the number of each in that field. So if there are 4 a's 1 b 0 c's and 12 d's how can I get php to count this? _ MSN Photos is the

Re: [PHP] records in db

2002-08-10 Thread Analysis Solutions
On Sat, Aug 10, 2002 at 05:52:42PM +, Tyler Durdin wrote: If I have a field in my DB that can have 4 different answers, lets say a,b,c and d. How can I count the number of each in that field. So if there are 4 a's 1 b 0 c's and 12 d's how can I get php to count this? Us the database to

Re: [PHP] records in db

2002-08-10 Thread DL Neil
Tyler, If I have a field in my DB that can have 4 different answers, lets say a,b,c and d. How can I count the number of each in that field. So if there are 4 a's 1 b 0 c's and 12 d's how can I get php to count this? You must combine IF() with SUM(). Break it down into smaller problems: 1

Re: [PHP] records in db

2002-08-10 Thread Justin French
on 11/08/02 3:52 AM, Tyler Durdin ([EMAIL PROTECTED]) wrote: If I have a field in my DB that can have 4 different answers, lets say a,b,c and d. How can I count the number of each in that field. So if there are 4 a's 1 b 0 c's and 12 d's how can I get php to count this? I'm pretty certain