need some help

Rav

I am facing a problem of data inserted twice. Its not the same everytime but exhibits erratic behavior.

User submits a request from a html form to create a new playlist. Code instantiates a new user object and calls a member function to add a new playlist for the user. Code in the member function creates a sql statement and executes it. Problem I am facing is that every other request (random) creates a double entery in the DB(mysql).

Code: php script
....

if($SESSION["USER"]){
$sessionUser = $SESSION["USER"];
$user = new user($sessionUser["ID"]);

   if($action == "ADD_NEW_PL"){
$newplname = $_REQUEST["newplname"];
if($newplname != ""){					$user->addNewPlaylist($newplname);		}	
   }

}

Code in the member function:

function addNewPlaylist($plname)
{
$sql = "INSERT INTO PLAYLIST (NAME, USERINFO_ID) VALUES ('$plname', '$this->Id')";
$this->query($sql);
}

the query is excuted at the base object level which is extended by user object.

At the html form level a javascript code submits this form:

Any insight into what is/might be the problem would be appreciated.

suntra

You could post, as an attachment, the whole code. Thanks !

Rav

I have attached a txt file conatining php script and user class code. The php script is run as a part of an outer conatiner script so may not work as such but mostly it is self sufficient. User class uses a base object to execute the sql quary and other encryption code to encrypt and decrypt. Most of the logic is executed by the php script which is included.

thanks

suntra

In which contect does it happen (what action) ??

Rav

This happens when user submits a request to create a new playlist. (ADD_NEW_PL)

Rav

Suntra

Did you find anything. Any thoughts.

suntra

I'll check later. Presently, I don't have time for that !

Sorry !