query problem

bbmak

I try to sort my data by region and the alphabetical order for each page

the code is okay this way

$query = 'SELECT * FROM artist WHERE LEFT(english_name, 1) = "'.$_GET['letter'].'" ORDER BY english_name ASC';

but when i add region = '.us.' into the query, i have problem display, and it gives me this error message
Unknown column 'a' in 'where clause'

$query = "SELECT * FROM artist WHERE region = '.us.' AND LEFT(english_name, 1) = ".$_GET['letter']."";

How can i fix the problem???

planetsim

$query = "SELECT * FROM artist WHERE region = '.us.' AND LEFT(english_name, 1) = ".$_GET['letter']."";

Is interpretted as this for example

SELECT * FROM artist WHERE region = '.us.' AND LEFT(english_name, 1) = a

You have no single quotes signifying that a is not a field (column) name.

$query = "SELECT * FROM artist WHERE region = '.us.' AND LEFT(english_name, 1) = '".$_GET['letter']."'";

Try that I added the single quotes in, also I suggest validating $_GET['letter'] as that could be anything, even an SQL Injection Attack (do a good search on what that is).

bbmak

thank you so much. I got it work. I am a person who always caught on small mistakes.
After I add the ' ' everything is okay