[SOLVED] Ordering By Letters

[Cless]

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.

[The Little Guy]

How are you getting these names?? SQL?

[Cless]

Yes.

[Wildbug]

SELECT username FROM table WHERE username LIKE 'c%' ORDER BY username;

[The Little Guy]

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>';
}
?>

[Cless]

I see. Thanks a lot.

[Cless]

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?

[The Little Guy]

<?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.

[Cless]

OH! Sorry, I thought it was a spelling error.

 

Thanks.