有错!更正如下
$sql="SELECT max(id) FROM asd ";
$result=mysql_query($sql,$db);
上面两句后,如何取出需要的最大值max(id) ?
$sql="SELECT max(id) FROM asd ";
$result=mysql_query($sql,$db);
上面两句后,如何取出需要的最大值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)"];
}