Forums

PHP

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.

Reply to this topic