PHP HELP!! working wid flex

[akshay]

Hi,
I am working on a project to visualize weather data from cumulus. the data from multiple stations is fed into the data base server and i wanna use that data for real interactive visualization.

Decided to use flex for it (flash builder4)...and php as a server side technology....

the DB contains data frm cumulus monthly file..

can anyone (all php gurus out here) help me with some insight to fetch data from mysql using php to get it into xml or AMF so it can be used in flex for interactive display(charts etc...)


any any help n suggestions are appreciated

thanks
Akshay

[daj]

See my post here. https://cumulus.hosiene.co.uk/viewtopic.php?f=18&t=2373

check out the read_dayfile.php in the zip file as it does what you ask.

Reads data from a MYSQL database table and produces it in a XML format

[akshay]

Hi Daj,
Thanks so much for ur guidance....i can get started i guess...
hope i can get the read_dayfile.php to run for my DB table....just confirming on ur table schema..

table name:dayfile

UKLogDate(PK),HighWindGust,HWindGBear,THWindG,MinTemp,TMinTemp,MaxTemp,TMaxTemp,MinPress,
TMinPress,MaxPress,TMaxPress,MaxRainRate,TMaxRR,TotRainFall,AvgTemp,TotWindRun

sry daj, i am just too new to php so pardon my ignorance...