I have a .swf which has one movieclip in it. I have a php script with the following code:
<?php
include "dbConnect.php";
$collection = "1";
$sql = "SELECT *
FROM pots p, collection c
WHERE p.collection = c.collectionID
AND $collection = c.collectionID";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
?>
I want to make it so that this php script tells flash how many rows are returned and then flash can duplicate the clip that many times and load a result(row) into each one. This would make a dynamic product gallery, but so far my newbiesh attempts at this have failed badly i haven't even been able to get the variable $num_rows into flash 🙁
has anyone done something like this before and if so.. can you help?