Hi Greg,
I've tried several methods, unsuccessfully, to display the result of the mysql_count function. I want to display the count of the equipment_type from my inventory section, so according to your code I should have it like this somewhere:
mysql_count('inventory', "equipment_type = '6'");
*note: the inventory section records pulls in the 'equipment_type" from a separate section called 'equipment_type', so the number '6' above represents bulldozers, as an example.
If I have code, from my inventory section to display on an index.php page, like the following:
<?php if ($record['equipment_type']): ?>
<?php echo $record['equipment_type'] ?>
<?php endif ?>
and it displays something like:
Bulldozers
and I want to use CMSB's mysql_count function and display the results, say 16 bulldozers like:
Bulldozers (16)
How would I code that on the php page?
Thank you in advance!