Hi sir Ned,

Thanks for the reply.

I already done this in AS2 code here it is:

// code for trackUserL.php

if (!$_REQUEST[userId]) exit;

if ($_REQUEST[rprod]==1) {

          mysql_query("update tblproduct set loaded=NOW() where  viewed<>1 and prodId='$_REQUEST[userId]'");

}

else {

          mysql_query("update tbluser set loaded=NOW() where viewed<>1 and userId='$_REQUEST[userId]'");

}

// end for trackUserL.php

// code for trackUser.php

if (!$_REQUEST[userId]) exit;

if ($_REQUEST[rprod]==1) {

          mysql_query("update tblproduct set End=NOW() where viewed<>1 and prodId='$_REQUEST[userId]'");

}

else {

          mysql_query("update tbluser set viewedDateEnd=NOW() where  viewed<>1 and userId='$_REQUEST[userId]'");

}

// end for trackUser.php

_root.createEmptyMovieClip("tmp",900);

_root.createEmptyMovieClip("tmpLoded",101);

_root.interval = setInterval(_root.logger,5000);

loadVariables("http://www.domain.com/trackUserL.php?userId="+_root.userId+"&rprod="+_root.rprod+"&str="+_root.generateRandomStr() ,_root.tmpLoded);

function logger () {

    loadVariables("http://www.domain.com/trackUser.php?userId="+_root.userId+"&str="+_root.generateRandomStr(),_root.tmp);

}

function generateRandomStr () {

var dt = new Date();

var str = dt.getMilliseconds()+""+dt.getSeconds()+""+dt.getMinutes()+""+dt.getH ours()+""+dt.getDate()+""+dt.getMonth()+""+dt.getFullYear();

return str;

}

I have a hard time converting this code to get it to work in AS3.

I googled something like flashvars by using URLRequest, URLLoader, URLVariables but I didn't notice how to access the variables loaded from the url.

I want to load a php file (trackUserL.php) that query a "userId" and "prodId" in the database and use it on my flash to determine if the user is a registered member and what product he is viewing.

After which I'll pass the loaded userId from trackUserL.php to another php file trackUser.php under function logger that updates the database every 5 seconds.

I know its confusing cause in my first post I thought it is a querystring but It is accessing variables that is fetched by php from the database.