# Please help: mySQL woes

**URL:** <https://forum.kirupa.com/t/please-help-mysql-woes/223755>\
**Category:** programming\
**Created:** [April 25, 2007, 2:37pm UTC](https://forum.kirupa.com/t/please-help-mysql-woes/223755 "2007-04-25T14:37:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![monkeysaurus](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/monkeysaurus/32/3554_2.png) [@monkeysaurus](https://forum.kirupa.com/u/monkeysaurus)\
**Post date:** [April 25, 2007, 2:37pm UTC](https://forum.kirupa.com/t/please-help-mysql-woes/223755/1 "2007-04-25T14:37:41Z")

</div>

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]

```auto
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.