I'm not sure I get everything you said, but you can easily form queues to an SQL server using POST or GET vars.
For example, you can have your code like this:
- <?php
-
if(!isset($_GET['action'])) die("No action set.");
-
-
switch($_GET['action'])
-
{
-
case "update":
-
$query = "UPDATE table SET somerow={$_GET['var1']} WHERE id={$_GET['id']}";
-
.......................
-
}
-
?>
Then, you can update a row by simply requesting an URL like this:
http://myserver/myscript.php?action=...&var1=sometext
This is easily doable in AS using flash.net.URLRequest
However, security can be pretty tough issue when accessing databases like this. You would have to consider any possible of input that could be sent to the said script. For example, the above code is vulnerable to being hijacked through a simple SQL injection.
