当一次获取多个查询字段时，查询字段不会分开 - Query fields won't separate when getting more than one at a time

Query fields won't separate when getting more than one at a time

本文关键字：查询字段一次获取 | 更新日期: 2023-09-27

当我运行这个查询时，它工作得很好，但是单个字段会退出。比如ThumbFilePath和Title。

如果我运行查询只有一个字段，如:

$result = mysql_query("select ThumbFilePath from artwork where SCID = $SCID") or die(mysql_error());

很好。知道为什么我不能拉其他字段吗?

<?php
    $dbname = 'pdartist2';
    $table = 'artowrk';
    // query
    $result = mysql_query("select AID, ThumbFilePath, Title, DisplayOrder from artwork where SCID = $SCID") or die(mysql_error());
    while($row = mysql_fetch_row($result))
    {
        foreach($row as $cell)
        {
            echo "<div id='thumb_container'>";        
            echo "
<a href='gallery_detail.php?AID=$AID'>
 <img src='http://markdinwiddie.com/PHP2012/$ThumbFilePath' title='Enlarge' alt='Enlarge' border='0'>
</a>
";
            echo "$Title";
            echo "</div>";
        }
    }
    mysql_free_result($result);
?>

一般情况下，您总是需要取消对所需列的引用。例如:

  while($row = mysql_fetch_row($result)) {
      $aid = $row['AID'];
      $tpath= $row['ThumbFilePath'];
      $title = $row['title'];
      ...

<?php
  $dbname = 'pdartist2';
  $table = 'artowrk';
  // query
  $sql = "select AID, ThumbFilePath, Title, DisplayOrder from artwork where SCID = $SCID";
  $result = mysql_query($sql) or die(mysql_error());
  while($row = mysql_fetch_row($result)) {
    $AID = $row['AID'];
    $ThumbFilePath= $row['ThumbFilePath'];
    $Title = $row['Title'];
    $DisplayOrder = $row['DisplayOrder'];
    echo "<div id='clear'></div>";
    echo "<div id='thumb_container'>";
    echo "<a href='gallery_detail.php?AID=$AID'><img src='http://markdinwiddie.com/PHP2012/$ThumbFilePath' title='Enlarge' alt='Enlarge' border='0'></a>";
    echo "<div id='name_spacer'></div>";
    echo "<div id='thumbdesc'>";
    echo "$Title";
    echo "</div>";
    echo "</div>";
  }
  mysql_free_result($result);
?>