function listallips()
  {
      //$search4ip = $_GET['search4ip'];
      
      $query = "SELECT id,assignedips,dedicatedip FROM tblhosting";
      $result = mysql_query($query) or die(mysql_error());
      
      $ipArray = array();
      $hostArray = array();
      
      while ($data = mysql_fetch_array($result)) {
          $hostid = $data['id'];
          $hostArray[] = $hostid;
          
          $dedicatedip = $data['dedicatedip'];
          $assignedips = $data['assignedips'];
          
          $ipArrayInit = explode(";", trim($assignedips));
          
          if ($dedicatedip != "") {
              $ipArray[] = $dedicatedip;
          }
          
          foreach ($ipArrayInit as $v) {
              if ($v != "") {
                  if (stristr($v, '-')) {
                      $ipArrayFinal = explode("-", trim($v));
                      foreach (range(ip2long(trim($ipArrayFinal[0])), ip2long(trim($ipArrayFinal[1]))) as $number) {
                          $ipArray[] = long2ip($number);
                      }
                  } else {
                      $ipArray[] = $v;
                  }
              }
          }
      }
      
      //  $ipArray[] = $var;
      
      echo "<pre>";
      print_r($hostArray);
      echo "</pre>";
      
      echo "<pre>";
      print_r($ipArray);
      echo "</pre>";
  }