I'm using flashbuilder 4 beta 2 along with a php service to pull and graph data from my SQL database.
Pulling data using my php service works fine when I have a static query built into my php service file, however, I want to use the selection, say from my drop down menu query, date selection etc to be passed on as the variable into the next query within my php service.
I'm relativley new to flashbuilder and coding in general, and would like to know the most efficient way of doing this.
Any help would be appreciated!
You can try using DCD in FB4 for this purpose.
You can find details on the blog :
Also the blog http://sujitreddyg.wordpress.com/flash-builder-4/ contains other ways of connecting to php.
THe blog you sent me is the part that I can already do.
What I can't do is pass the selection from say from the data grid or drop down menu, or a date chooser onto the next query as a variable.
For a simple example, say I have a database containing the following columns.
Names, Age, weight on a weekly basis
I want to pass my name selection forward to my age selection, and then plot their weight over a designated time period defined by a start and end date date chooser.
So that I plot everyone called Bob, aged 25 weight over the past 3 months.
I can write the individual SQL queries for this, but cannot generate them depending on my return from Flashbuilder.
Thank again for your help.