PHP MYSQL 结果不完整

Question

此代码有效，除非 $market 返回多个单词。IE:科罗拉多州将归还普韦布洛，这可行。当它返回“colorado springs”时，$market 仅回显“colorado”，而 SID 从不显示。很抱歉，代码可能很丑陋，但这是我所遵循的一切。

$pickstate = $_POST['state'];
    $result = mysql_query("SELECT * FROM ppc WHERE State='" . $pickstate . "'");
      if (!$result) {
        echo("<P>Error performing query: " .
             mysql_error() . "</P>");
       exit();
  }

echo '<form action="" method="POST"><select id="Market" name="Market">';

while ($row = mysql_fetch_array($result)) {
    echo ( '<option value= '.$row['Market'].' onclick="this.form.submit();">'.$row['Market'].'</option>' );
}
echo "</select></form>";

$market = $_POST['Market'];
echo "Market = " . $market . "<br />";
$sid = mysql_query("SELECT SID FROM ppc WHERE Market='" . $market . "'");
while ($row = mysql_fetch_array($sid)) {
    echo '<p>SID = ' . $row['SID'] . '</p><br />';
}

Answer 1

考虑到您的实际代码，您必须更改

echo "<option value=" . $row['Market'] . " onclick=\"this.form.submit();\" . $row['Market'] . "</option>";

到此

echo "<option value=" . $row['Market'] . " onclick=\"this.form.submit();\"" . $row['Market'] . "</option>";

此外，您可以考虑在编写这些行时考虑到可读性，如下所示:

echo ( '<option value= '.$row['Market'].' onclick="this.form.submit();"'.$row['Market'].'</option>' );

结合不同类型的引号会有所帮助。当您必须输出双引号时，请尝试用单引号括起来。