re: Count of children

[Rob Desbois]

Your sentence 'I want the count of all sub-entries for a specific entry' converts straight
into SQL:

'I want'
    SELECT
the count of all entries
    COUNT(*) FROM myTable
with a specific parent
    WHERE parent_id = 5

You've missed one of the major benefits of SQL - it's designed to read like an English
sentence!
--Rob


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________