$sql="SELECT max(id) as id FROM asd "; $result=mysql_query($sql,$db); $re=$result['id'];
(1)字段名下标返回 $sql="SELECT max(id) as tid FROM asd "; $result=mysql_query($sql,$db); $rst=mysql_fetch_array($result); $valx=$rst[tid]; (2)数字索引下标返回 $sql="SELECT max(id) FROM asd "; $result=mysql_query($sql,$db); $rst=mysql_fetch_row($result); $valx=$rst[0]; (3)对象返回 $sql="SELECT max(id) as tid FROM asd "; $result=mysql_query($sql,$db); $rst=mysql_fetch_object($result); $valx=$rst->tid;
不行,提示如下: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137
$sql="SELECT max(id) FROM asd "; $quoteresult=mysql_query($qsql,$db); if ($row = mysql_fetch_array($quoteresult)) { $id =$row["max(id)"]; }
$result=mysql_query($sql,$db);
$re=$result['id'];
$sql="SELECT max(id) as tid FROM asd ";
$result=mysql_query($sql,$db);
$rst=mysql_fetch_array($result);
$valx=$rst[tid];
(2)数字索引下标返回
$sql="SELECT max(id) FROM asd ";
$result=mysql_query($sql,$db);
$rst=mysql_fetch_row($result);
$valx=$rst[0];
(3)对象返回
$sql="SELECT max(id) as tid FROM asd ";
$result=mysql_query($sql,$db);
$rst=mysql_fetch_object($result);
$valx=$rst->tid;
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in E:\RAT\quote\quote.php on line 137
$quoteresult=mysql_query($qsql,$db);
if ($row = mysql_fetch_array($quoteresult))
{
$id =$row["max(id)"];
}