Please explain about the connectivity of data using AMFPHP between the flash frontend and the mysql database?
A simple answer:-
AMFPHP allows an enabled flash or silverlight or javascript app to call functions and methods declared in the PHP backend.
So if your backend php is returning a value, the flash/sl/js can pick it up and run with it.