Cless Posted July 18, 2007 Share Posted July 18, 2007 Hello. Is there a way to, say, have a Member's List, however, make it ordered by a certain method, though, making it so it only display a certain character at the start... or something. Um, what I mean is posting every user's name, however, sorting it by a certain letter. So, on a page, if I want it to display names that only start with c, it displays all names that start with c. Thanks. Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/ Share on other sites More sharing options...
The Little Guy Posted July 18, 2007 Share Posted July 18, 2007 How are you getting these names?? SQL? Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301421 Share on other sites More sharing options...
Cless Posted July 18, 2007 Author Share Posted July 18, 2007 Yes. Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301430 Share on other sites More sharing options...
Wildbug Posted July 18, 2007 Share Posted July 18, 2007 SELECT username FROM table WHERE username LIKE 'c%' ORDER BY username; Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301464 Share on other sites More sharing options...
The Little Guy Posted July 18, 2007 Share Posted July 18, 2007 example: <?php $letter = addslashes($_GET['letter']); $query = "SELECT * FROM dog_list WHERE dogType LIKE '$letter%' ORDER by dogType"; $sql = mysql_query($query); while($row = mysql_fetch_array($sql)){ echo $row['dogType'].'<br>'; } ?> Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301465 Share on other sites More sharing options...
Cless Posted July 18, 2007 Author Share Posted July 18, 2007 I see. Thanks a lot. Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301483 Share on other sites More sharing options...
Cless Posted July 18, 2007 Author Share Posted July 18, 2007 Sorry for double posting. >_> Umm, wait, topic not resolved. I don't quite get it. I replaced all of the tables and such, however, it doesn't seem to work. This is what I tried.. $letter = addslashes($_GET['letter']); $query = "SELECT * FROM Users WHERE Username LIKE '$letter' ORDER by Username"; $sql = mysql_query($query); while($row = mysql_fetch_array($sql)){ echo $row['Username'].'<br>'; } What exactly do I have to do? Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301509 Share on other sites More sharing options...
The Little Guy Posted July 18, 2007 Share Posted July 18, 2007 <?php $letter = addslashes($_GET['letter']); $query = "SELECT * FROM Users WHERE Username LIKE '$letter%' ORDER by Username"; $sql = mysql_query($query); while($row = mysql_fetch_array($sql)){ echo $row['Username'].'<br>'; }?> You need the % after $letter, so it looks like this: LIKE '$letter%' ORDER The % is a wild card meaning everything, so if the letter is f, and you have % after it, it would look for anything starting with an f followed by anthing else. if you have ca% it would look for things that start with ca, and anything else after that. Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301511 Share on other sites More sharing options...
Cless Posted July 18, 2007 Author Share Posted July 18, 2007 OH! Sorry, I thought it was a spelling error. Thanks. Link to comment https://forums.phpfreaks.com/topic/60592-solved-ordering-by-letters/#findComment-301516 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.