试试吧…这是我的工作实例
排序记录字母顺序A B C D
……当我
点击字母
那么它的
以字母开头显示所有名称
,然后单击“C字母”,它的“显示所有名称”以C字母开头。
$host = "localhost";
$user = "root";
$pw = "";
$database = "test";
$con = mysql_connect($host,$user,$pw)
or die("Cannot connect to mySQL.");
mysql_select_db($database,$con)
or die("Cannot connect to database.");
$errormsg= "No Record Found...!";
$alpha="%";
if (isset($_REQUEST['alpha'])) {
$alpha = $_REQUEST['alpha']."%";
}
$q1 = mysql_query("select * from registration where firstname like '$alpha%' " );
?>
Sort by Alphabet:
| A
| B
| C
| D
| E
| F
| G
| H
| I
| J
| K
| L
| M
| N
| O
| P
| Q
| R
| S
| T
| U
| V
| W
| X
| Y
| Z
$i=1;
$num_rows=mysql_num_rows($q1);
if($num_rows==0)
{
?>
}
else
{
while($roww=mysql_fetch_array($q1))
{
?>
: <?php echo $roww["firstname"]; ?>
$i++;
}
?>