Help with DAO design pattern

[carlg]

I'm trying to create some PHP code and I'm trying to cleanly organize everything.

Let's assume I have an account object.  I'm trying to figure out (from a design perspective) the best way to do this:

 

Here is approach #1.

 

class Account {
      public $id;
      
      function getAccounts ()
     {
          // I know this code doesn't work, but it demonstrates the point
           mysql_query ("Select * from Account");
     }
}

 

 

Approach #2:

or is is better to have the getAccounts in a separate DAO class (called AccountDAO) so in my main program I would declare an Account object and an AccountDAO object?

 

I'm really trying to figure out the preferred way to structure my application.