怎样获得一个出生日期最小的人的名字

[wwchar]

假设表为person(name,birth)

[victoryall]

$sql=select * from person ORDER BY birth";
$result=mysql_query($sql);
$names=mysql_fetch_array($result);

$names["name"] 就是出生日期最小的人的名字.

[victoryall]

$smallname=$names["name"];或
$smallname=$names[0];

都可以.

[wwchar]

Thank you all.
"order by" and "limit" are also supported in mysql.

[xuzuning]

select name from person ORDER BY birth limit 1

[bonniewater]

$sqlmin=select min(birth) as min_birth from person";
$sql = "select * from person where birth = min_birth";

[okdw]

birth如果是date类型的就用唠叨的语句就行

[wsyab]

select name from person ORDER BY birth limit 1
------------------------------------------------
mysql不支持order by和limit合用



birth如果是date类型的就用唠叨的语句就行
-------------------------------------------
其他类型也可以啊

[wwchar]

我想要用sql语句直接获得。

[wwchar]

继续问，谢谢了