Forums
This topic is locked
Nested/Filtered Recordsets using PHP & DW8
Posted 02 Sep 2006 05:51:57
1
has voted
02 Sep 2006 05:51:57 Chris Truitt posted:
I need to create nested/filtered recordsets. Are there any good tutorials around?Here's what I need to do:
Author Name (main recordset)
Number of Stories for Subject 1 (sub recordset)
Number of Stories for Subject 2 (sub recordset)
Number of Stories for Subject 3 (sub recordset)
Database has a table named Stories. Fields include Author, Author's Company, Subject, etc.
The rs for Author Name will be filtered by Author's Company. For each author in the rs I need to then count the total number of stories written on each subject.
So...first rs is filtered by a form field (Author's Company), second rs is filtered by the Author Name from the first rs. I can do this in ASP...but I'm new to PHP.
Thanks!
Replies
Replied 03 Oct 2006 19:58:37
03 Oct 2006 19:58:37 Tracy Sweder replied:
I'm not sure on the filtering aspect, but if you do a search for Tom Muck you should find his website. I know he has various different extensions (some free) for allowing dreamweaver to do nested recordsets.