sorting on alphabet

[Stinos]

Okay,

I have a question about sorting on alphabet.

I have a tabel in my database with interviews.

It contains three fields,
- bandname
- interview
- author

But I'm quite a noob in PHP and I want to extract the interviews from the database and sort it on the first letter of the bandname.

I know how to select sql etc. but I don't know how i have to sort the bandnames on alphabet.

Can somebody give me an example?

thanks

[robtbs]

$query = "SELECT * FROM ".INTERVIEW_TABLE." ORDER BY bandname ".$direction."";
mysql_query($query) or die('error in query');

//change direction to....
ASC for accending
DESC for decending