Listing MySQL Database Table Using PHP, XML and DataGrid Component

This is an example of using Flash XML class to request records in a MySQL table via PHP. All the scripting and database commands are listed below. All the ActionScript is on frame 1 of the XMLPHPMySQLEx01_Request Flash movie plus a DataGrid component named myUserDataGrid and a TextField named output_txt that displays output for testing outside the Flash IDE.

mySQL users Table Structure
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(15) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `firstname` varchar(20) NOT NULL default '',
  `lastname` varchar(35) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `userID` (`userid`),
  FULLTEXT KEY `userID_2` (`userid`)
) TYPE=MyISAM COMMENT='Practice php session login' AUTO_INCREMENT=14 ;


INSERT INTO `users` VALUES (12, 'dangerbear', '2ef982b077e30936', 'grizzly', 'bear', 'grizzly@mountaincaves.com', 'Blah blah blah blah blah.');
INSERT INTO `users` VALUES (13, 'picnicbasket', '6af828fd21f6ca94', 'yoggi', 'bear', 'yoggi@park.com', 'Likes picnic basket contents.');