Say for example I have the follwoing DB structure

Table book

• id
• title
• ...

Table Author

• id
• name
• ...

Table BookAuthor

• id
• bookid
• authorid

And in PHP I have the following object

class Book {
  var $id;
  var $title;
  var $authors = array();

  function Book() {}
}

class Author {
  var $id;
  var $name;

  function Author(){}
}

Now, would it be possible using mysql_fetch_object to retrieve the bookobject including the authors as an array of author objects?

If it's possible I'm pretty sure you'll need the basic inner join query

SELECT * FROM tblbook INNER JOIN tblbookauthor on ... (wel you get the point)

Is it possible?

thanks!