laxman
|
| Posted: 01/24/2002, 11:51 AM |
|
number_of_items = cn.execute("select count(*) from items group by category_id =" & fldcategory_id).fields.item(0)
fldname = fldname & "(" & number_of_items & ")"
this is asp code
ok
what it wul be in php ?
|
|
|
 |
Alex Alexapolsky
|
| Posted: 01/25/2002, 2:32 AM |
|
Please read documentation about phplib , a set of db functions used in CC.
$db->query("select count(*) from items group by category_id =" & fldcategory_id);
if ($db->next_record()) {
$number_of_items = $db->f(0);
}
//this line homework
fldname = fldname & "(" & number_of_items & ")"
|
|
|
|
|
