Need some DB help

[eluser]sandwormusmc[/eluser]

Code:

$sql='SELECT * FROM `books` LEFT OUTER JOIN author ON book_author_id=author.author_id;';
  $result=$this->db->query($sql);
  // error checking
  // return something from the result, i.e. $result->result_array() or $result->result_object()

Otherwise you might be doing 100*N DB queries for 100 books, checking for their authors. The above will be a large data set, too, but refining your SELECT portion to only include the columns you need should help performance.