Please help: mySQL woes

programming
1

Hi all, I’ve been building a flash snippet which queries a mySQL database and returns the status of a property (sold, reserved, etc). I’ve never attempted to connect an .swf to a database before, and what looked straightforward is actually anything but!

Here’s what I have so far:

[flash]

onClipEvent(load){
    c = new LoadVars();
    c.id = _global.id;
    c.availability = ""
    c.sendAndLoad("flashquery.php", c.availability, "POST");
    propa = "Property " + _global.id + " is " + c.availability + "."
}

I’m confident the PHP is doing its job, but flash is stubbornly refusing to pull a value. Any help would be very much appreciated!

Thanks in advance.