php-general Digest 1 Mar 2012 15:09:02 -0000 Issue 7708

2012-03-01 Thread php-general-digest-help
php-general Digest 1 Mar 2012 15:09:02 - Issue 7708 Topics (messages 316816 through 316821): time/task reporting 316816 by: Robert Nilsson 316817 by: Fatih P. 316818 by: Stuart Dallas Re: Website preview script 316819 by: Stuart Dallas Nested database loops

php-general Digest 2 Mar 2012 05:24:20 -0000 Issue 7709

2012-03-01 Thread php-general-digest-help
php-general Digest 2 Mar 2012 05:24:20 - Issue 7709 Topics (messages 316822 through 316833): Re: Nested database loops and completing an unordered list 316822 by: FeIn 316823 by: Tommy Pham 316824 by: Jay Blanchard 316825 by: Jay Blanchard 316827

[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

Re: [PHP] time/task reporting

2012-03-01 Thread Fatih P.
On Thu, Mar 1, 2012 at 10:43 AM, Robert Nilsson rob...@myself.com 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

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 the

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 a new

[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

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

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 aci...@gmail.com wrote: I don't how how you keep your data in your database but there is no need to issues that

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 jay.blanch...@sigmaphinothing.org 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

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:

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

[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:

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] =

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] = BUSTIER1DATA

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 Tommy Pham
On Thu, Mar 1, 2012 at 4:36 PM, Jay Blanchard jay.blanch...@sigmaphinothing.org 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] =

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 have an array of tiers….

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 Bastien
On 2012-03-01, at 9:20 PM, Jay Blanchard jay.blanch...@sigmaphinothing.org 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