[RESOLVED] Maybe I've gon to far: not a valid MySQL result resource

[The_Stewart]

I need a little help. I want to select all results that begin with a letter and sort them.

$breeds = mysql_query("SELECT * FROM table WHERE column LIKE '$letter%' SORT BY column ACS");

while($row = mysql_fetch_array($breeds))
    	{ Do some stuff }

I'm being told that the error is one the line with while on it.

[laserlight]

Change SORT BY to ORDER BY. Also, try to select only those columns you will use.

[bradgrafelman]

Note that the way MySQL errors are usually debugged is like so:

$query = 'SELECT blah blah...';
$exec = mysql_query($query) or die('MySQL error: ' . mysql_error() . '<hr>Query: ' . $query);

The MySQL error message usually gives you a pretty good hint as to where in the query it found a problem so that you can go to the MySQL manual for an answer.

[The_Stewart]

I don't know that was going wrong. The ORDER BY did help. In the end I rewrote the entire section. And here is the little bit of code that now works:

mysql_query("SELECT * FROM table WHERE dog LIKE '$letter%' ORDER BY dog ASC");

Thanks for the help.