hi again
something is going wrong. Although i am able to duplicate the movieclip (_root.dp) i cannot pass the vars into the moviclip.
myLoadbleData = new LoadVars();
myLoadbleData.load(“http://www.damofli.com/news/fetch_categories_and_news.php?id=1”);
percentLoaded = myLoadbleData.getBytesLoaded()/myLoadbleData.getBytesTotal();
myLoadbleData.onLoad = function(success) {
myArray = new Array();
if (success) {
trace(“variables loaded”);
for (var i = 1; i<this.new_count; i++) {
_root.dp.duplicateMovieClip(“nn”+i, i+200);
root[“nn”+i].y = (i-1)*150;
eval(“nn”+i).ana = eval("new_name" add i);
eval(“nn”+i).aid = eval("new_id" add i);
new_image._visible = 1;
new_scrollbar._visible = 1;
new_instructions_object.text = new_instructions;
}
gotoAndPlay(1);
} else {
gotoAndPlay(224);
// The data didn?t load at all. Display error
}
};
stop();
php code
require (“database.inc”);
$DB = new Database;
if ($search) {
$query = "SELECT id, name FROM news " .
“WHERE MATCH (name, author, instructions) AGAINST (” .
$DB->quote($search) . “)”;
} else {
$query = "SELECT news.id, news.name " .
"FROM news, new_category_xref AS xref " .
“WHERE news.id=xref.new_id " .
“AND xref.category_id=” . $DB->quote($id) .
" ORDER BY news.name”;
}
$result = $DB->query($query);
$i = 0;
while (list($news_id, $news_name) = mysql_fetch_row($result)) {
echo “new_id_” . $i . “=” . $news_id . “&”;
echo “new_name_” . $i . “=” . urlencode($news_name) . “&”;
$i++;
}
echo “new_count=” . $i . “&”;
mysql_free_result ($result);
if ($search) {
echo “cat_count=0&”;
$id = 0;
} else {
$query = “SELECT id, name FROM categories " .
“WHERE parent_id=” . $DB->quote($id) .
" ORDER BY name”;
$result = $DB->query($query);
$i = 0;
while (list($cat_id, $cat_name) =
mysql_fetch_row($result)) {
echo “cat_id_” . $i . “=” . $cat_id . “&”;
echo “cat_name_” . $i . “=” . urlencode($cat_name) .
“&”;
$i++;
}
echo “cat_count=” . $i . “&”;
}
if ($id==0) {
echo “parent_id=0&category_name=” .
urlencode($cookbook_name);
} else {
$query = “SELECT parent_id, name FROM categories WHERE id=” . $DB->quote($id);
$result = $DB->query($query);
$i = 0;
list($cat_id, $cat_name) = mysql_fetch_row($result);
echo “parent_id=” . $cat_id . “&”;
echo “category_name=” . urlencode($cookbook_name .
": " . $cat_name);
}
?>
please help