RE: [PHP] categorise list

2003-06-09 Thread John W. Holmes
> I am dispalying data from mysql database using the codes below: > > $while($row=mysql_fetch_array($result)) > { > echo $row[name]; > } > > How can i format the above data in this format as shown below? in > alphabetical order > > A >

Re: [PHP] categorise list

2003-06-09 Thread Bas Jobsen
$letter=''; $while($row=mysql_fetch_array($result)) { if($letter!=$row[name][0]) { echo $row[name][0].''; $letter=$row[name][0]; } echo $row[name].''; } Op maandag 09 juni 2003 12:41, schreef u: > I am dispalying data from mysql database using the codes below: > > $while($row=mysql_fetch_array($

[PHP] categorise list

2003-06-09 Thread Awlad Hussain
I am dispalying data from mysql database using the codes below: $while($row=mysql_fetch_array($result)) { echo $row[name]; } How can i format the above data in this format as shown below? in alphabetical order A ---