PHP
<?php$conn = mysql_connect("localhost","username","password");$db = mysql_select_db("database");echo "<?xml version=\"1.0\" encode=\"UTF-8\"?>";echo "<firstChild>";$select = mysql_query("SELECT * FROM `Scotland` ORDER BY `id` ASC") or die(mysql_error());whilte($row = mysql_fetch_array($select)); {echo "<picture image=\"".$row[""]."\";}echo "</firstChild>";?>
Flash
var spacing = 20;function GenerateGallery(galllery_xml) { var GalleryPictures = gallery_xml.firstChild.childNodes; for (var i = 0; i<galleryPictures.length; i++) { var currentPicture = galleryPictures[i]; var currentThumb_mc = place.createEmptyMovieClip("pictures"+i, i); currentThumb_mc._x = i*spacing; currentThumb_mc.onRelease = function() { image_mc.loadMovie(this.image); description_lv.load(this.description); }; }}var gallery_xml = new XML();gallery_xml.ignoreWhite = true;gallery_xml.onLoad = function(success) { if (success) { GenerateGallery(this); } else { trace("Error loading XML file"); }};gallery_xml.load("gallery.php");
image of the database is attached i just have no idea!