Re: Accumilating Blog Comments

[Philippe Poelvoorde]

2006/4/25, -Patrick <[EMAIL PROTECTED]>:
> $query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
> date_com ASC", $KTColParam1_rsComments);
>
>
> can anyone see what Im trying to do here? basically, I want to match the
> id_com with an idart_com to produce a value and report back through the
> other chunk of code already given to output a number.. using
> mysql_num_rows(). But Im getting syntax and check line errors..
>
> Any thoughts?
> -Patrick

You should use count(*) to get the rows number, if it's the only thing you want.
Why is your inner join enclosed in parenthesis ??

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]