$Sql = "SELECT MAX(attachmentid) FROM attachment"; $query = mysql_query($sql); $res = mysql_fetch_array($query) foreach($res as $RES){ echo number_format($RES[maxattachmentid])."<br>\n"; }