Re: Feed data from MySQL/PHP

5 views
Skip to first unread message
Message has been deleted

Graham Watson

unread,
Sep 4, 2008, 10:36:23 AM9/4/08
to Google Chart API
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
Reply all
Reply to author
Forward
0 new messages