[SOLVED] SQL groupings

[komquat]

I have a DB that has 100 records.  All of them are file names.  I would like to group them alphabetically.  How can I do this?

 

Output example:

 

A

-------------------

Andy.gif

Apple.jpg

Azurite.pdf

 

B

-------------------

Bob.xls

 

 

And so on.

 

Help is greatly appreciated.

 

 

[rcorlew]

$query2 = "SELECT * FROM table WHERE variable = '$variable' ORDER BY filename"; //Would put it alphabetically

[Canman2005]

You can use GROUP BY xx (xx being the field name) if you want to show just one of each and not show any duplicates

[komquat]

In the GROUP BY, can you select DESC or ASC, similar to the SORT BY?

 

If I have a file name, how would I only leave the first letter of that filename

 

example

 

$file = sample.doc;
$file_first_letter = ??????;

 

Is there something that will give me the first letter of the value in the variable I have?

 

Thanks again

[per1os]

www.php.net/substr

 

<?php
$file = 'sample.doc';

$firstLetter = substr(0, 1, $file);
?>

 

No the group by does not use the desc or asc, that is strictly order by.