mysql查询第三个字母是a的员工_按字母顺序排列MySQL查询

试试吧…这是我的工作实例

排序记录字母顺序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:

All

| 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"]; ?>

: <?php echo $roww["firstname"]; ?>

$i++;

}

?>