I’ve been working on a news manager and i have some difficulties.
First of all i would like to know if there is a way to preload variables from my php script.
In addition, i want to use three identical sets of movieclips without having to load the vars individually for each set ex.
_root.holder.loadVariables(“http://www.damofli.com/news/fetch_categories_and_news.php?id=1”);
_root.holder2.loadVariables(“http://www.damofli.com/news/fetch_categories_and_news.php?id=1”);
_root.holder3.loadVariables(http://www.damofli.com/news/fetch_categories_and_news.php?id=1);
Actionscript for the holder moviclip:
onClipEvent (data) {
for (i=0; i<new_count; i++) {
root.holder2.dp.duplicateMovieClip(“nn”+i, i+200);
eval(“nn”+i).aid = eval("new_id" add i);
eval(“nn”+i).ana = eval(“new_name_” add i);
_root.holder2[“nn”+i]._y = (i-1)*150;
new_image._visible = 1;
new_scrollbar._visible = 1;
new_instructions_object.text = new_instructions;
}
}
PHP script
<?
require (“db.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);
}
?>
Thanx in advance