$query = "SELECT COUNT(id) as total FROM table"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); $row = mysql_fetch_array($result); $id = $row['id']; echo $id;