Question

当我处理这一询问时,它会进行细微的工作,但各个领域将会撤出。同<代码>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);
?>

Answer 1

总体而言,你需要参考你需要的栏目。例如:

  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);
?>

友情链接