question about query syntax

[bbmak]

how do i do this syntax?
I try to sort the artist by gender, categorize them A B C D by using '".$_letter."%' and order from asc

error is here, and i do not how to fix it
gender='$gender' english_name LIKE '".$_letter."%'

This one has error syntax
$query=("SELECT artist_id,artist_name,english_name,gender FROM artist WHERE gender='$gender' english_name LIKE '".$_letter."%' ORDER BY 'english_name' ASC ");

[bbmak]

i solve the problem by adding AND
$query=("SELECT artist_id,artist_name,english_name,gender FROM artist WHERE english_name LIKE '".$_letter."%' AND gender='$gender' ORDER BY 'english_name' ASC ");

[Lars_Berg]

Remove the quotes in the order by clause, i.e.

ORDER BY english_name