komquat Posted April 20, 2007 Share Posted April 20, 2007 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. Quote Link to comment Share on other sites More sharing options...
rcorlew Posted April 20, 2007 Share Posted April 20, 2007 $query2 = "SELECT * FROM table WHERE variable = '$variable' ORDER BY filename"; //Would put it alphabetically Quote Link to comment Share on other sites More sharing options...
Canman2005 Posted April 20, 2007 Share Posted April 20, 2007 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 Quote Link to comment Share on other sites More sharing options...
komquat Posted April 20, 2007 Author Share Posted April 20, 2007 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 Quote Link to comment Share on other sites More sharing options...
per1os Posted April 20, 2007 Share Posted April 20, 2007 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.