Re: Sorting

[Christian Mack]

Jody wrote:
> 
> OK I added that "ORDER BY" and had another look at the manual...
> 
> but now im getting an error on line 15
> 
> $result=mysql_query("SELECT * FROM Items WHERE Category='$CA' ORDER BY '$IN'
> ASCENDING");
< cut >

The part after ORDER BY has to be a column number or a column name not a variable.
If you don't know the column name for the second column, just use:
"SELECT * FROM Items WHERE Category='$CA' ORDER BY 2 ASC"

Tschau
Christian