Making a graph from values held in phpmyadmin database

[pb1uk]

Hello all,

I have a table in a phpmyadmin database holding information of teams scores. The table is called tbl_teams and the fields are pointswk1_team, pointswk2_team etc upto 5. I'm using Dreamweaver CS4 and have setup a recordset that will get the information from one users team. The recordset only fetches information about 1 team in the table as it is filtered using a session variable.

With these results i would like to display a simple line graph or bar chart, which ever is easiest really! so that a user can see the progress of their team.

Any help or advice would be appreciated.

Ideally i would like to achieve this without the use of an extension.

Thanks,

Peter

[David_Powers]

pb1uk wrote:

I have a table in a phpmyadmin database

No you don't. phpMyAdmin is simply a front-end for MySQL. Your database is in MySQL, not phpMyAdmin.

I know it sounds like a nitpick, but if you're going to be working with PHP and MySQL, you need a good understanding of the various parts, and how they fit together.

With these results i would like to display a simple line graph or bar chart, which ever is easiest really! so that a user can see the progress of their team.

Dreamweaver can't do it out of the box. You need to do some serious coding yourself. Do a Google search for "create a graph with PHP". You'll come up with some useful links and tutorials. The better you understand PHP, the easier you'll find it to do.