[SOLVED] Reading Data out of MYSQL database and Making it into Graph

[winmastergames]

This might be a big Thing but here we go:

Well i am making a Website and its using a mysql database to hold this data:

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 14, 2008 at 10:25 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `webmeterreadgrid`
--

-- --------------------------------------------------------

--
-- Table structure for table `sslvl11hr`
--

CREATE TABLE IF NOT EXISTS `sslvl11hr` (
  `record` int(80) NOT NULL,
  `datetime` text NOT NULL,
  `whtotal` int(80) NOT NULL,
  `voltabcmin` text NOT NULL,
  `voltabcmax` text NOT NULL,
  `freqmin` text NOT NULL,
  `freqmax` text NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY  (`record`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sslvl11hr`
--

INSERT INTO `sslvl11hr` (`record`, `datetime`, `whtotal`, `voltabcmin`, `voltabcmax`, `freqmin`, `freqmax`, `status`) VALUES
(243, '7/06/2008 16:00', 1254, '231.89', '234.42', '49.906', '50.098', '.......'),
(242, '7/06/2008 15:00', 500, '231.66', '235.82', '49.949', '50.113', '.......'),
(241, '7/06/2008 14:00', 535, '232.26', '233.64', '49.902', '50.074', '.......'),
(240, '7/06/2008 13:00', 515, '230.95', '235.32', '49.836', '50.105', '.......'),
(239, '7/06/2008 12:00', 537, '231.09', '232.94', '49.93', '50.074', '.......'),
(238, '7/06/2008 11:00', 505, '231.96', '233.3', '49.926', '50.082', '.......'),
(236, '7/06/2008 9:00', 540, '231.17', '234.51', '49.797', '50.141', '.......'),
(237, '7/06/2008 10:00', 1207, '227.04', '236.38', '49.902', '50.105', '.......'),
(235, '7/06/2008 8:00', 526, '232.08', '237.24', '49.875', '50.109', '.......'),
(233, '7/06/2008 6:00', 499, '234.08', '237.29', '49.898', '50.102', '.......'),
(234, '7/06/2008 7:00', 546, '234.69', '235.99', '49.875', '50.188', '.......'),
(232, '7/06/2008 5:00', 876, '233.21', '236.57', '49.879', '50.109', '.......'),

it just goes on for alot more but yea It has this data I want to be able to in a form have all the Date and times in dropdown boxes you select the "From" date and then the "To" date it uses that to create a graph of the dates and inbetween the dates to use Google's Chart API to create the graph of those time periods are there any Examples on the internet of this kind of thing or can you help me make this

Thanks Heaps

 

EDIT: Here is the link to Google Chart API http://code.google.com/apis/chart/

[winmastergames]

Sorry About this Did google search and found a few tutorials heres link http://www.google.co.nz/search?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&channel=s&hl=en&q=Make+Mysql+and+PHP+Graph&meta=&btnG=Google+Search