带有子查询和分组的php mysql查询

Question

I am trying to fill a table with informations out of a query but i am getting error 500. What am I doing wrong?

for($count = 0; $count < $200; $count++)
    {
    $result = mysql_query("SELECT jp.ARTNUM, jp.BEZEICHNUNG, SUM(jp.MENGE), RDATUM
                        FROM journalpos jp, journal j
                        WHERE j.REC_ID=jp.JOURNAL_ID AND ARTNUM IS NOT NULL AND jp.JOURNAL_ID IN
                        (SELECT REC_ID FROM journal WHERE RDATUM BETWEEN NOW() - INTERVAL 1 DAY AND NOW() )
                        GROUP BY ARTNUM 
                        LIMIT $count , 30")
    or die(mysql_error());
    $row = mysql_fetch_array( $result );
    echo "<tr>";
    echo "<td>";
    echo $row['jp.ARTNUM'];
    echo "</td>";

    echo "<td>";
    echo $row['jp.BEZEICHNUNG'];
    echo "</td>";

    echo "<td>";
    echo $row['SUM(jp.MENGE)'];
    echo "</td>";

    echo "<td>";
    echo $row['RDATUM'];
    echo "</td>";
    echo "</tr>";
    }

It worked without the SUM function (then i can leave GROUP BY away) and without the subquery !

Answer 1

One error I found is in this line

for($count = 0; $count < $200; $count++)

$200 is incorrect syntax.