分组SQL查询

Question

I am working on a movie archive management system, I need to group the query results in the cases with more than one result

For example, when a user searches a director name(e.g. Steven), There are movies of Steven A, Steven B and Steven C,(multiple) what I want to do is display all movies of Steven A under his name, Steven B under his name etc.

How can I do this with php and mysql

Thanks

Answer 1

Use ORDER BY director_name. This will cause rows with the same name to be listed together.

You can also use some code in PHP to detect when the director name changes add a header if you wish to make the change from one director to the next more obvious.

while (/* read row */)
{
    $director_name = ...; // Implement this.

    if ($previous_director_name !== $director_name) {
        echo ...; // Output director's name.
        $previous_director_name = $director_name;
    }

    echo ...; // Output row.
}