arent.
HTH.
C.
-Original Message-
From: Mark Rees [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 13:39
To: php-general@lists.php.net
Subject: Re: [PHP] MySQL + PHP question
*
This e-mail has been received by the Revenue Internet
On Tue, 2005-07-26 at 13:39 +0100, Mark Rees wrote:
> "André Medeiros" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > One thing I didn't quite explain myself well... I'm building this to
> > register objects on a permission system.
> >
> > The SQL weight is heavy as it is, and I
"André Medeiros" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> One thing I didn't quite explain myself well... I'm building this to
> register objects on a permission system.
>
> The SQL weight is heavy as it is, and I want to save queries as much as
> possible. Making two queries t
You're missing the point here. I know how to get the parent project's
info. I know recursiveness. I _JUST_ don't know how to get the current
and parent project's info in just ONE QUERY (since I'm trying to save
them because the sql weight is getting pretty heavy).
--
PHP General Mailing List (htt
One thing I didn't quite explain myself well... I'm building this to
register objects on a permission system.
The SQL weight is heavy as it is, and I want to save queries as much as
possible. Making two queries to extract information about a project and
it's parent is not something I'd want to do.
t on MySQL, but this query should work on MSSQL and Oracle.
HTH.
C.
-Original Message-
From: André Medeiros [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 12:53
To: Shaw, Chris - Accenture
Cc: php-general@lists.php.net
Subject: RE: [PHP] MySQL + PH
riginal Message-
From: André Medeiros [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 12:18
To: php-general@lists.php.net
Subject: [PHP] MySQL + PHP question
Hi guys.
I'm having some trouble here regarding a project. I have a table with
projects, wich can be recursive (ie. sub-projects) and it
ill overwrite the object's properties).
If not... heck, I'll have to make another query or use the associative
array sollution (wich neither will make me very happy, but that's life).
Thanks for your prompt reply :)
>
> C.
> -Original Message-----
> From: An
ject 5, do you want to find out its parent (2), or do
you want to find out all its parents including grandparents (2) and (1)?
What do you need to know?
C.
-Original Message-
From: André Medeiros [mailto:[EMAIL PROTECTED]
Sent: 26 July 2005 12:18
To: php-general@lists.php.net
Subject: [
Hi guys.
I'm having some trouble here regarding a project. I have a table with
projects, wich can be recursive (ie. sub-projects) and it is related to
itself.
By making the following query
-8<--
SELECT * FROM projects LEFT JOIN projects proj_parent ON
10 matches
Mail list logo
