按顺序对结果
lastname进行
MySQL排序,并跟踪第一个字母的变化
PHP:
<?php$rs = mysql_query("SELECt * FROM mytable ORDER BY lastname");while ($rec = mysql_fetch_assoc($rs)) { if ($initial !== strtoupper(substr($rec['lastname'], 0, 1)) { $initial = strtoupper(substr($rec['lastname'], 0, 1)); print "$initialn"; } print $rec['lastname'] . "n";}?>


