how to make combination between Flash and PHP and MYSQl to get dynamic data into SWF file??

iam trying to make a project with flash and i need to connect a mysql data base through PHP page to get data and show it in the flash file.
but i got mad because i spent big time and there is no results :(
this is the code of the data basw wihch contain only one table:

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: phpflash
# --------------------------------------------------------
# Server version 3.23.47-nt


#
# Table structure for table 'countries'
#

CREATE TABLE countries (
  country_id int(3) unsigned NOT NULL auto_increment,
  country_name text,
  country_markets int(10) unsigned default NULL,
  country_sales int(10) unsigned default NULL,
  PRIMARY KEY  (country_id),
  KEY country_id (country_id)
) TYPE=MyISAM;



#
# Dumping data for table 'countries'
#

INSERT INTO countries VALUES("1", "Damanhour", "120", "5000");
INSERT INTO countries VALUES("2", "Shebeen", "130", "6000");
INSERT INTO countries VALUES("3", "Domyat", "140", "7000");
INSERT INTO countries VALUES("4", "Giza", "150", "8000");
INSERT INTO countries VALUES("5", "Alexandria", "160", "9000");
INSERT INTO countries VALUES("6", "Cairo", "170", "10000");


the table contain informations for 6 countries
i need to make a flash file which load the data from the table and show this data in a container moveiclip
i want  empty movie clips in the flash file when i put the mouse over any empty movieclip i want the flash file to display the data about this movie clip (certain country ) on the flash which will get from the data base
thanks for help
LVL 13
FLAASHERAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
krishnaprathabConnect With a Mentor Commented:
Hi,

Check out the links below, especially the second one is really very good and can address you problem in a more easier way:

www.macromedia.com/devnet/mx/ flash/articles/amfphp.html
actionscript-toolbox.com/samplemx_php.php

Thanks,
kp
0
 
FLAASHERAuthor Commented:
i will try
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.