$query = "select SQL_CALC_FOUND_ROWS * from `employees` WHERE `login`='$login'"; $result = mysql_query($query, $link) or Die(mysql_error()); $query2 = "Select FOUND_ROWS()"; $result2 = mysql_fetch_array(mysql_query($query2, $link)); $numrows = $result2['FOUND_ROWS()'];