Hi all,

I'm trying to recreate my blog using OOP and having a problem working out how to solve the following problem..

I have an ArticleCollection class (extends Collection class) that stores Articles (singleton's -is that right?).

Currently Articles takes a single parameter (article_id) and loads the information from a database.

I want ArticleCollection to loop through all the records in my database and create a new Article instance, then store it in an array / object, so I can access them when I want.

This is where I'm getting troubled, I would need to connect to the DB in ArticleCollection (for all records) AND Article (for the individual record), this smell's like I'm duplicating code. How should I approach this?

I've not written any code yet, trying to get it clear in my head before I set out.

Cheers.

__________________
Pro. Geek
http://www.mikeholloway.co.uk