A recursive algorithm is the term used for an algorithm where a function
calls itself. Listing the entire directory structure of your hard drive
would employ such an algorithm. Any good book on programming should explain
recursive algorithms. You may find that helpful.
----- Original Message -----
From: "Phil Latio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 20:52
Subject: Re: Help with SQL statement please.
> I see, I need a recursive algorithm
>
> Can you get them in Woolworths?
>
>
>
> ----- Original Message -----
> From: "Tommie Jones" <[EMAIL PROTECTED]>
> To: "Phil Latio" <[EMAIL PROTECTED]>
> Cc: <>
> Sent: Thursday, February 08, 2001 12:18 PM
> Subject: Re: Help with SQL statement please.
>
>
> > If I am not mistaken I think you are trying to do a nested select.
> >
> > This is not possible in Mysql. I've had similar problems.
> > You will have to use some sort of recursive algorithm in your perl code
> > (if you are using perl)
> > to accomplish this.
> > Phil Latio wrote:
> > >
> > > 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
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
