Jump to content

[SOLVED] Ordering By Letters


Cless

Recommended Posts

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

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?

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.