如何整合 COUNT(*)? [英] How to integrate COUNT(*)?

问题描述

<?php
    $dbname = 'pdartist2';
    $table = 'artwork';
    $result = mysql_query("select AID, ThumbFilePath, Title, DisplayOrder from artwork where SCID = $SCID order by DisplayOrder") or die(mysql_error());
while($row = mysql_fetch_array($result)){   
    $AID = $row['AID'];
    $ThumbFilePath = $row['ThumbFilePath'];
    $Title = $row['Title'];
    $DisplayOrder = $row['DisplayOrder'];
    $RecordCount = $row['Count']; {
            $ColCount = $ColCount+1;
        if ($ColCount ==5) {
            echo "<div id='clear'></div>";
            $ColCount = 1;
    }
    echo "<div id='thumb' onClick='window.location='gallery_detail.php?AID=AID';' title='Enlarge'>";
    echo "<div id='thumb_container'>";
    echo "<a href='gallery_detail.php?AID=$AID'><img src='/$ThumbFilePath' title='Enlarge' alt='Enlarge' border='0'></a>";
    echo "<div id='name_spacer'>";
    ($ColCount);
    echo "<div id='thumbdesc'>$Title</div>";
    echo "</div>";
    echo "</div>";
    echo "</div>";
    }       
}
    mysql_free_result($result);
    ?>

当我运行此查询时，它可以正常工作.当我添加 COUNT() 时出现问题.我需要这样的东西:

When I run this query it works as it should. The problem arises when I add the COUNT(). I need to have something like this:

$result = mysql_query("select AID, ThumbFilePath, Title, DisplayOrder, COUNT(*) AS RecordCount from artwork  where SCID = $SCID order by DisplayOrder") or die(mysql_error());   

但是那个查询的结果并不是它应该的样子.

But the result from that query is not what it should be.

推荐答案

我认为您希望获得总行数，但 COUNT(*) 会自动将它们组合在一起.

I think you want to have the total row count, but COUNT(*) automatically groups them together.

考虑使用子查询.

$result = mysql_query("select AID, ThumbFilePath, Title, DisplayOrder, (SELECT COUNT(*) FROM artwork WHERE SCID=$SCID) ResultCount FROM artwork  where SCID = $SCID order by DisplayOrder") or die(mysql_error());

这篇关于如何整合 COUNT(*)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！