Question

php mysql 语句问题

$area = "select * from area where areaCode = ".$rows['area'];
$re = $conn->db_query($area);
$ro = mysql_fetch_assoc($re);
$aN = $ro['areaName'];

为什么简化成这样不行?
$area = "select areaName as $ aN from area where areaCode = ".$rows['area'];
$conn->db_query($area);

Answer 1

$area = "select * from area where areaCode = ".$rows['area'];
areaCode是int类型的字段才可以，否则应该这样：
$area = "select * from area where areaCode = '".$rows['area']."'";

$area = "select areaName as $ aN from area where areaCode = '".$rows['area']."'";是
取一个字段的值了，而上面是取一条或多条记录，根据你的需要了。

Answer 2

$area = "select areaName as $ aN from area where areaCode = ".$rows['area'];
能这样写吗？

Answer 3

想简单就封装一下吧