php - Mysql 查询结果

Question

我的mysql查询结果示例在这里;

    id = 45
species = Felis
generic = Leo
labidenlabel = S131
accessnumber = 4545
specimen = Blood
storedas = DNA
storedat = aDNA
storin = Beko Refrigerator

我想看到他们喜欢；

        id = 45
species Name = Felis
generic Name = Leo
labiden Label = S131
Access number = 4545
specimen = Blood
stored As = DNA
stored At = aDNA
store In = Beko Refrigerator 

等等

还有我的 php 代码，我想更改结果区域。不是mysql字段，需要看具体名称。

抱歉我的英语不好...

   <?php
     error_reporting(1);
    $speci1=$_GET['id'];

    $baglan=mysql_connect("localhost","root","");
    if(!$baglan){
     die('Bağlantı Hatası:' . mysql_error()); 
    }
    $sec=mysql_select_db("test",$baglan);

    $sql= "SELECT * from bilgiler where id='$speci1'";


    $sorgu=mysql_query($sql,$baglan);
    if(mysql_num_rows($sorgu) > 0){
            $satir=mysql_fetch_assoc($sorgu);

            foreach ($satir as $key => &$value) {

                    echo $key . ' = ' . $value . '<br />';
            }
    }else{
        echo "Kayıt Bulunamadı!";
    }
    ?>

如何更改结果页面？谢谢。

Answer 1

使用 mysql alias .而不是

select * from

使用

select id, species as 'species Name', ... from