Help "count" records

Got it, that worked great, thanks for the response! -Ken

"David Powers" <david@example.com> wrote in message
news:elpmf8$mhu$1@forums.macromedia.com...
> KP wrote:
>> Is each query in it's own recordset or both in one?
>
> Separate.
>
> --
> David Powers, Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

KP wrote:
> Is each query in it's own recordset or both in one?

Separate.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Is each query in it's own recordset or both in one?


"David Powers" <david@example.com> wrote in message
news:elpiob$idh$1@forums.macromedia.com...
> KP wrote:
>> I want to count all records in a recordset based on the value and then
>> determine the % of records that have that value. Any pointers on how to
>> do this would be appreciated. -Thanks
>
> Create two SQL queries.
>
> SELECT COUNT(columnName) FROM myTable
>
> SELECT COUNT(columName) FROM myTable
> WHERE columnName = variableValue
>
> Divide the result of the second query by the result of the first and
> multiply by 100.
>
> --
> David Powers, Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

KP wrote:
> I want to count all records in a recordset based on the value and then
> determine the % of records that have that value. Any pointers on how to do
> this would be appreciated. -Thanks

Create two SQL queries.

SELECT COUNT(columnName) FROM myTable

SELECT COUNT(columName) FROM myTable
WHERE columnName = variableValue

Divide the result of the second query by the result of the first and
multiply by 100.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/