Here is my Flash Action Script:
[SIZE=“1”]
on (release) {
myVars = new LoadVars();
myVars.val = sector_01_var;
myVars.col = sector_01_status;
//myVars.SendAndLoad(“http://www.jrphosting.co.uk/wellq/wellq_write_record.php”, myVars, “POST”);
myVars.SendAndLoad(“http://www.jrphosting.co.uk/wellq/wellq_write_record.php”, “_out”, “POST”);
gotoAndStop(25);
}
[/SIZE]
Here is my PHP script:
[SIZE=“1”]
<?php
include(“db.inc”);
$conn=@mysql_connect("$db_address", "$db_username", "$db_password") or DIE("Could not connect to MySQL.");
$rs = @mysql_select_db("$db_name",$conn) or DIE("Could not select database.");
$sql = "INSERT INTO $db_table (wqr_sector_01_v, wqr_sector_01_c, wqr_uid) VALUES ('$var', '$col', '00000007')";
$rs = @mysql_query($sql,$conn) or DIE("could not execute query - get package details.");
mysql_close($conn);
?>
[/SIZE]
Problem:
The PHP script works if you send it with data, such as:
http://www.jrphosting.co.uk/wellq/wellq_write_record.php?var=3&col=R
…it appears in the database fine…
http://www.jrphosting.co.uk/wellq/wellq_read_record.php
BUT Flash will not do it?
http://www.jrphosting.co.uk/wellq/
I’m stumped, help!