Philippe Poelvoorde wrote:
> 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 ??
>
>
Or, can I use count to make statements inside the query? I almost have
it... but it's off because now it's gathering every id_com and putting
them all in one idart_com.. not to it's relative idart_com.. very
frustrating..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
