PHP Chart

Can't find anything to do this

[Chris_m]

I have a weight loss site, when I track my weekly weight loss. I have to enter all the table rows and data into html my self. I'd like to automate this but i can't fine any php scrips that do what I need.

I need something that would print out:

date ¦ weight ¦ change ¦ total loss
----------------------------------------------------------
1/2/04¦ 130 ¦ -2 ¦ -5

With a form to enter the data, like a php email form does.

Does anyone know of any scripts like this? I'm somewhat php literate and don't mind altering something for my needs but I don't know how to code a whole script.

[brucec]

Hi Chris,
If your web hosting company supports PHP, then find out if it supports MySQL, because MySQL works well with PHP as a database tool. You can simply enter each line or row of your table into a MySQL database and then call it up with the PHP.

This will automatically draw all the HTML table data for you on the fly and if you know basic SQL, you will be able to do all kinds of queries and sorts.

Bruce :)

[edited by: brucec at 9:47 pm (utc) on Jan. 23, 2004]

[brucec]

Also, I forgot to mention that you can also use PHP arrays to add the information. You can make one array for each line of the HTML (not the most efficient way to accomplish this in PHP), but it will work.

Brush up on your PHP array skills. LOL.