Skip to main content
P
pb1uk
Participant
March 1, 2010
Question

Making a graph from values held in phpmyadmin database

  • March 1, 2010
  • 1 reply
  • 1339 views

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

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
March 2, 2010

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices