Re: Help with SQL statement please.

2001-02-09 Thread Bob Hall
>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 "lca

Re: Help with SQL statement please.

2001-02-08 Thread Rolf Hopkins
- 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 M

Re: Help with SQL statement please.

2001-02-08 Thread Phil Latio
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

Re: Help with SQL statement please.

2001-02-08 Thread Tommie Jones
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 acro

Help with SQL statement please.

2001-02-08 Thread Phil Latio
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" (