hey guys here is my query string
mysql_query("SELECT * FROM names WHERE name like '%A%';ORDER BY name ASC");

This Table row contains a single word name My query works but it will pull all names with a (a) in them. Can someone tell me how to match only the first letter of the name so I can display all names with a or b or c you get the idea.

Thanks in advance

In SQL the % works as a wildcard, so '%A%' will match anything containing an A. To only match words beginning with an A use 'A%' instead.

Also, you should remove the semicolon from the query, since that will otherwise mark the end of the query and the rest (ORDER BY name ASC) will be ignored or attempted to run as a seperate query (probably ignored since your not getting any errors).

So, to sum it up, your query should look like this

SELECT * FROM names WHERE name like 'A%' ORDER BY name ASC

Thanks I new it had to be simple But I have been banging my head on the wall for hours.

The ; was a typo Thanks it gave an error and I removed it.