我有一个查询，它在表中查找给定名称的最大值并返回该数字。它在SQL控制台中工作得很好。但是，我试图获取该值，然后在HTML表中创建单选按钮，尽管有数据，但它是一个空集。它总是只有一个值，因此不需要数组。表中可以有多个同名条目，但不是同样的网。

$sqltankonly = "SELECT * FROM HoldingUnit WHERE tankfacility = 'test' AND net = '0' ORDER BY name"; // Select Holding Units that are not nets
$resulttankonly = $conn->query($sqltankonly); // Select Holding Units that are not nets unless they have something in them

if ($resulttankonly->num_rows > 0) {
  // Setup Table
  echo '<table><tr><th>Destination Tank</th><th>Net</th></tr>';
  while($row = $resulttankonly->fetch_assoc()) {
    echo '<tr><td><input type="radio" name="dtank" " value="' . $row["name"] . '" required>' . $row["name"] . '</td>';
    echo '<td>';

// Below is my problem *******************

    $sqlnetcapacity = 'SELECT MAX(net) FROM HoldingUnit WHERE name="' . $row["name"] . '"';
    $resultnetcapacity = $conn->query($sqlnetcapacity);
    $netcapacity = $conn->query('SELECT MAX(net) FROM HoldingUnit WHERE name="Test-01"')->fetch_object()->net;
    while($netcapacity > 0) {
      echo '<input type="radio" name="net" value="' . $netcapacity . '" />' . $netcapacity . ';
      $netcapacity = $netcapacity - 1;
    }
  }
  echo '</td></tr></table>';

我试着把$resultnetcapacity当作一个数组，用while循环代替fetch_object（）。我试着只打印值，即使if语句证明有多于0个值，也没有显示。