[SOLVED] mysql query select order by alpabets??

[yami007]

how can i display the contents ordered by alphabets?

well, i want to get the results this way:

<div>A</div>

<div>akon...</div>

<div>amine...</div>

<div>amel...</div>

<div>B</div>

<div>bryan...</div>

<div>britanie...</div>

so on.....

 

please help

[MadTechie]

Append "ORDER BY field name ASC" to the SQL statment

[yami007]

well, i'm already doing what u said; order by name, but what i want to do is like in this page http://myplay.com/artists.

i hope u help me with it

[MadTechie]

Okay and whats the problem ?

its basically a while loop check first char is its diffrent then echo the new one

quick draft untested example

$letter = "";
while($row = mysql_fetch_array($result))
{
$fletter = substr($row['0'],0, 1);
if($letter != $fletter)
{
$letter = $fletter;
echo "$letter<br>";
}
echo $row['0']."<br>";
}

 

the rest is basically CSS/HTML

[yami007]

i dont think i get your code, i tried it though and it gave me :

5

 

4

 

5

 

6

 

5

 

6

 

5

 

what's that supposed to mean??

[Mark Baker]

So if row[0] isn't the content retrieved from your database, pick the column that is

[yami007]

sorry madtechie, i think i was sleepy so i ddn concetrate on it, thanks to you and mark baker for waking me up

[yami007]

ok guys that's how i turned this code into :

<?php 
 $query ="SELECT * FROM singers ORDER BY name";
 $singers_set = mysql_query($query);
 while ($singers = mysql_fetch_array($singers_set)) {
 $fletter = substr($singers['name'],0, 1);
 if ($letter != $fletter) {
   $letter = $fletter;
   echo "$letter<br>";
 }
 echo $singers['name']."<br>";
 }
?>

[MadTechie]

Sorry for late reply Mark Baker is correct if you used "SELECT name  FROM singers ORDER BY name" the code should of worked

 

i didn't know the field names being used and i don't really test the code i just enter it directly..

anywho glade you got it sorted

[yami007]

thanks so much