I have a page that displays a book and some of its chapters (not all chapters are recorded) and I want to do a layout like this:
ISN: 012345678X Book Title: A Christmas Carol Book Author: Dickens, C. Publisher: Victorian Press Year: 1934 Dickens, C Chapter One:title 1-33 Last sold for 5p per page Digitised Dickens, C Chapter Two:title 34-43 Last sold for 5p per page Digitised Dickens, C Chapter Three:title 44-63 Not Cleared Not Digitised Dickens, C Chapter Six :title 92-114 Last sold for 5p per page Digitised Now, I know I could do 2 queries, 1 against the book table and the other against the chapter table. Would it be possible and if so more efficient to combine them into a single query and still be able to display in this way? MTIA George in Edinburgh (data is fictional in more ways than one) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/02 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]