Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Bastien
On 2012-03-01, at 9:20 PM, Jay Blanchard wrote: >> [snip] >> Can you show the output of the function above? >> [/snip] > > 0 > SELECT DISTINCT `TIER1DATA` FROM `POSITION_SETUP` WHERE `COMPANY_ID` = '3' > Executives and Management > > Normally this query alone returns 9 rows of data. Each of

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
> [snip] > Can you show the output of the function above? > [/snip] 0 SELECT DISTINCT `TIER1DATA` FROM `POSITION_SETUP` WHERE `COMPANY_ID` = '3' Executives and Management Normally this query alone returns 9 rows of data. Each of these rows should be included in the next query where TIER1DATA =

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
On Mar 1, 2012, at 7:45 PM, Jim Lucas wrote: > On 03/01/2012 04:39 PM, Jay Blanchard wrote: >> >> On Mar 1, 2012, at 6:36 PM, Jay Blanchard wrote: >> >>> [snip]…stuff…[/snip] >>> >>> I am getting close, but I am also getting frustrated. I probably need to >>> walk away for a bit. >>> >>> I h

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Tommy Pham
On Thu, Mar 1, 2012 at 4:36 PM, Jay Blanchard wrote: > [snip]…stuff…[/snip] > > I am getting close, but I am also getting frustrated. I probably need to walk > away for a bit. > > I have an array of tiers…. > > Array > ( >    [0] => TIER1DATA >    [1] => TIER2DATA >    [2] => TIER3DATA >    [3] =

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jim Lucas
On 03/01/2012 04:39 PM, Jay Blanchard wrote: On Mar 1, 2012, at 6:36 PM, Jay Blanchard wrote: [snip]…stuff…[/snip] I am getting close, but I am also getting frustrated. I probably need to walk away for a bit. I have an array of tiers…. Array ( [0] => TIER1DATA [1] => TIER2DATA

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
On Mar 1, 2012, at 6:36 PM, Jay Blanchard wrote: > [snip]…stuff…[/snip] > > I am getting close, but I am also getting frustrated. I probably need to walk > away for a bit. > > I have an array of tiers…. > > Array > ( >[0] => TIER1DATA >[1] => TIER2DATA >[2] => TIER3DATA >[3] =

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
[snip]…stuff…[/snip] I am getting close, but I am also getting frustrated. I probably need to walk away for a bit. I have an array of tiers…. Array ( [0] => TIER1DATA [1] => TIER2DATA [2] => TIER3DATA [3] => BUSTIER1DATA [4] => BUSTIER2DATA [5] => BUSTIER3DATA [6] =>

[PHP] PHP 5.4.0 released!

2012-03-01 Thread David Soria Parra
Hello! The PHP Development Team would like to announce the immediate availability of PHP 5.4.0. This release is a major leap forward in the 5.x series, and includes a large number of new features and bug fixes. Release Announcement: http://www.php.net/releases/5_4_0.php Downloads:http

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
On 3/1/2012 9:59 AM, Jay Blanchard wrote: Thanks FeIn, I'll give these articles and methods a look this afternoon. I'm sure that it will lead to more questions, so I'll be back. I also forgot to say that I cannot modify the database structure - the client is very strict about that. But it does

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
Thanks FeIn, I'll give these articles and methods a look this afternoon. I'm sure that it will lead to more questions, so I'll be back. On 3/1/2012 9:16 AM, FeIn wrote: And see also this, which focuses only on the database part of the problem: http://mikehillyer.com/articles/managing-hierarchi

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Tommy Pham
On Thu, Mar 1, 2012 at 6:29 AM, Jay Blanchard wrote: > Good morning PHP groupies! > > I am working on this tool that will ultimately display a collapsible org > chart. The org chart is based on a nested unordered list and that is the > heart of my question. > > The NUL(nested unordered list) is ba

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread FeIn
And see also this, which focuses only on the database part of the problem: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/ On Thu, Mar 1, 2012 at 5:08 PM, FeIn wrote: > I don't how how you keep your data in your database but there is no need > to issues that many queries to

Re: [PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread FeIn
I don't how how you keep your data in your database but there is no need to issues that many queries to retrieve your data. From what I understand the data you want to display is hierarchical. Here's an article that will hopefully point you to a solution (there are more out there, some better than

[PHP] Nested database loops and completing an unordered list....

2012-03-01 Thread Jay Blanchard
Good morning PHP groupies! I am working on this tool that will ultimately display a collapsible org chart. The org chart is based on a nested unordered list and that is the heart of my question. The NUL(nested unordered list) is based on a set of database queries - sometimes as many as 14 qu

Re: [PHP] Website preview script

2012-03-01 Thread Stuart Dallas
On 1 Mar 2012, at 03:06, Nibin V M wrote: > But what my requirement here is, I need to display the website configured > on our server. No matter where the domain actually points to :) > > Perhaps it can call a proxyhere is the actual intention of creating > this script. > > Suppose X created

Re: [PHP] time/task reporting

2012-03-01 Thread Stuart Dallas
On 1 Mar 2012, at 08:43, Robert Nilsson wrote: > Ok, I admit -I'm lazy! > Been asked to make a reporting tool, what and how many hours spent on > Possible with a save option, to enable continuously adding during the week, > before sending off by mail to manager and one self. > > Surely I'm not t

Re: [PHP] time/task reporting

2012-03-01 Thread Fatih P.
On Thu, Mar 1, 2012 at 10:43 AM, Robert Nilsson wrote: > Hi, > Ok, I admit -I'm lazy! > Been asked to make a reporting tool, what and how many hours spent on > Possible with a save option, to enable continuously adding during the > week, before sending off by mail to manager and one self. > >

[PHP] time/task reporting

2012-03-01 Thread Robert Nilsson
Hi, Ok, I admit -I'm lazy! Been asked to make a reporting tool, what and how many hours spent on Possible with a save option, to enable continuously adding during the week, before sending off by mail to manager and one self. Surely I'm not the first person looking at a similar tool, been sear