Chart

Hi,

First I apologize for my english.

I am using MySQL and PHP.
I have a list of Tasks in a table.
Each Task has a status (started/completed/in progress/pending)
Each Task can be associated to a list of Parent Task.
Therefore, a task can start only if all its parent tasks have been
completed.

I would like to dynamically (the task order can change) and graphically show
this process in a web page.
Each task should be displayed in a box (or a circle) with its name and a
different color according to its status.
They should be displayed from top to bottom to know which one will start
first, and which one will start after etc etc until the last one.

Do you know a way to do it using a FREE component (java applet, flash...)?

Thanks you very much.

Rodolphe

"Rod" <toto@toto.com> wrote in message news:bmgujs$pmq$1@home.itg.ti.com...[color=blue]
> Hi,
>
> First I apologize for my english.
>
> I am using MySQL and PHP.
> I have a list of Tasks in a table.
> Each Task has a status (started/completed/in progress/pending)
> Each Task can be associated to a list of Parent Task.
> Therefore, a task can start only if all its parent tasks have been
> completed.
>
> I would like to dynamically (the task order can change) and graphically[/color]
show[color=blue]
> this process in a web page.
> Each task should be displayed in a box (or a circle) with its name and a
> different color according to its status.
> They should be displayed from top to bottom to know which one will start
> first, and which one will start after etc etc until the last one.
>
> Do you know a way to do it using a FREE component (java applet, flash...)?[/color]

You could do it with Flash and its ability to hook into PHP/MySQL but you'll
need a Flash newsgroup far more than you'll need this PHP newsgroup.

Paulus

Hi Rod!

On Tue, 14 Oct 2003 15:46:45 +0200, "Rod" <toto@toto.com> wrote:
[color=blue]
>Hi,
>
>First I apologize for my english.
>
>I am using MySQL and PHP.
>I have a list of Tasks in a table.
>Each Task has a status (started/completed/in progress/pending)
>Each Task can be associated to a list of Parent Task.
>Therefore, a task can start only if all its parent tasks have been
>completed.
>
>I would like to dynamically (the task order can change) and graphically show
>this process in a web page.
>Each task should be displayed in a box (or a circle) with its name and a
>different color according to its status.
>They should be displayed from top to bottom to know which one will start
>first, and which one will start after etc etc until the last one.[/color]

There is a very common way of displaying this, which is called a gantt
chart. JPGraph (www.aditus.nu/jpgraph) supports such graphs.

HTH, Jochen
--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

Hi Jochen,

thanks you very much for your answer.
Unfortunatelly, this is not exactly what I am searching for.
The process can be very complex.
Here is exactly what I would like:
http://www.componentsource.com/Asset...rge/513273.gif
But it is not free.

Do you know another component to do that?

thanks you very much

Rodolphe

Hi Rod!

On Wed, 15 Oct 2003 09:24:20 +0200, "Rod" <toto@toto.com> wrote:
[color=blue]
>Hi Jochen,
>
>thanks you very much for your answer.
>Unfortunatelly, this is not exactly what I am searching for.
>The process can be very complex.
>Here is exactly what I would like:
>http://www.componentsource.com/Asset...rge/513273.gif
>But it is not free.
>[/color]
Ok, now I understand. It looks complex in content, but simple in
display. Can you not do it yourself with the GD library? The only
problem are the places where the lines cross each other.

[color=blue]
>Do you know another component to do that?
>[/color]
Nope.

Jochen
--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/