关于获取与一行相关的多行的MySql查询问题

Question

I have table like below in my MySql database.

table_books

book_author         book_name                       book_page   book_price  book_published_date book_topic

James Anderson      Introduction to PHP             200         50          1/12/2013           Science
James Anderson      Expert in jQuery                150         40          8/7/2014            Programming
James Anderson      HTML                            200         60          5/9/2012            Web
Richard Benjamin    Successful stories of Business  300         70          4/6/2014            Business
Richard Benjamin    Entrepreneurship                500         80          8/9/2013            Business
Richard Benjamin    Business Studies                100         40          2/5/2012            Business

I would like to get result like below

book_author James Anderson              

book_name           book_page   book_price  book_published_date book_topic  

Introduction to PHP 200         50          1/12/2013           Science 
Expert in jQuery    150         40          8/7/2014            Programming 
HTML                200         60          5/9/2012            Web 




book_author Richard Benjamin                


book_name                       book_page   book_price  book_published_date book_topic  

Successful stories of Business  300         70          4/6/2014            Business    
Entrepreneurship                500         80          8/9/2013            Business    
Business Studies                100         40          2/5/2012            Business

I need the SQL Query. I need to pick up one row(book_author) with other associate rows.

Thanks

Answer 1

<?php
    $sqlAuthor = "SELECT DISTINCT book_author FROM book_name";
    $exeAuthor = mysql_query($sqlAuthor);
    if($exeAuthor)
    {
        while($dataAuthor = mysql_fetch_assoc($exeAuthor))
        {
            $sqlBookRec = "SELECT * FROM book_name where book_author='".$dataAuthor['book_author']."'";
            $exeBookRec = mysql_query($sqlBookRec);
            if($exeBookRec)
            {
                echo "Book Author: ".$dataAuthor['book_author'];
                while($dataBookRec = mysql_fetch_assoc($exeBookRec))
                {
                    echo "Book Name".$dataBookRec['book_name'];
                }
            }
        }
    }
?>

Try this. Hopefully, it'll work.