php mysql select eg sample example

php mysql select

$sql="select max(invoice) as maxinvoice from invhead " ;
$result=mysql_query($sql,$Invoice0connect) ; 
$row = mysql_fetch_array($result, MYSQL_NUM) ;
$lastnum = $row[0];
$lastnum = $lastnum +1 ;