Webmaster Forum / Flash / Data Integration / April 2006

Hi all! Bit of an urgent problem. I am trying to update a mySQL database via
flash and PHP where two variables are supplied, a name and a contact ID. I can
pass the variables to the php and check against two variables in the PHP to
check their validity, and I can run the mySQL update query with hardcoded
elements and the database updates. The only problem is when I try to pass the
variables through embeded in the query. Eg. in the PHP the query  $query =
"UPDATE contacts SET firstName = 'name' WHERE contactId = '1'"; works but
$query = "UPDATE contacts SET firstName = '$user' WHERE contactId = '$pass'";
doesn't. Apologies for the function code post, but the variables are passed
from Flash using the following code:

function login(user, pass) {
    myvars = new LoadVars();
    //set variables
    myvars.user = user;
    myvars.pass = pass;
    myvars.onLoad = action;
    myvars.sendAndLoad("the processingfile.php?random="+new Date().getTime(),
myvars);
}

Any replies would be greatly appreciated!