For questions like these, you can search through the resources at
http://php.net for basic information about things like MySQL
functions, loops, array traversal, and string concatenation.
What you'll be constructing is a loop to read through every row of
your table and concatenate each value (with the proper delimiters)
into variables for each collection of data, such as $years, $regions,
and $amounts. You'll then request a Google Chart with those values
substituted in for the appropriate parts of the image's URL.
On Sep 3, 1:23 pm, Al <
moua...@yahoo.com> wrote:
> I have this MySQL table name Sales.
>
> Year Region Amount
> 2007 West 100
> 2007 East 200
> 2007 North 300
> 2007 South 400
> 2008 West 500
> 2008 East 600
> 2008 North 700
> 2008 South 800
>
> I can't figure out how to get the data into some like below. A PHP
> multidimensional array would work for me as well. Thanks...
>
> "2007|2008", "West|East|North|South", "100,200,300,400|500,600,700,800