php - 漂亮的 MYSQL 打印数据的想法

Question

例如

id - Name - Surname - Phone - Married
1 - Ann - AnnS - 123 - No
2 - Mary - MarryS - [empty] - Yes
3 - Jane - JaneS - 321 - [empty]

现在我想按 id 记录并打印信息，如下所示(将行名称更改为其他内容，如果行为空 - 不要将行显示在全部):

SELECT * FROM `girls` WHERE `id`='1'

The girls name - Ann 
The girls surname - AnnS
The girls number - 123
Is the girl married? - No

/-/

SELECT * FROM `girls` WHERE `id`='2'

The girls name - Ann
The girls surname - AnnS
Is the girl married? - No

如何在不使服务器重载的情况下更轻松地完成任务(表中有大约 130 行)？

Answer 1

一次性选择它们

$sql = "select * from girls";

然后在php中迭代结果集

$result = mysql_query($mysql);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "The girls name - ".$row['name'].";
     //....
}