I hope somebody may of come across this sort of problem before dealing with
counting total records in subcategories.
I have two tables sslinks which contains links (URL) information and
sslinkcats which contains category information.
The category table "sslinkcats" has a field called "lcat_id" (which is an
autonumber) and also "lcat_cat" which is the "lcat_id" value of the parent
category. For example cricket would be under sport and the "lcat_cat" of
cricket would be "lcat_id" of sport.
The problem is that the below statement will only count the number of links
in each particular category.
$sql = "SELECT sslinkcats.lcat_id, COUNT(*) AS NumLinks
FROM sslinks, sslinkcats
WHERE link_cat = sslinkcats.lcat_id
AND link_validated = 'yes'
GROUP BY link_cat";
I want to display the total amount of links under the category sport to
include all subcategories like football,cricket,cricket rugby. Also if
cricket had subcategories, then I would these counted too.
I am sure the answer is looking at me but I just can't see it. Therefore any
pointers or assistance would be very welcome.
(ps. If you have read this message before, apologies but I was informed that
this is the correct category for this type of question. Sorry)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
