I am trying to insert data into a DB, but it won’t enter. Here is what I have for the AS:
on(release) {
if(new_player_name ne '')
{
gotoAndPlay(2);
new_player_name.loadVariables("create_player.php", "POST");
status = "Creating, please wait...";
}
else
{
status = "Enter a New Player Name";
}
}
And my PHP looks like this:
<?
include(’…/db/db_access.php’);
$player_name = $_POST[‘new_player_name’];
mysql_query(“insert into player set player_name=’$player_name’”);
$result = mysql_query(“select player_id from player where player_name=’$player_name’”);
$player_id = mysql_result($result, 0, ‘player_id’);
$result = mysql_query(“insert into old_position (player_id, oldx_tile, oldy_tile, on_map) values (’$player_id’, ‘7’, ‘7’, ‘1’)”);
print “status = Created&checklog=1”;
?>
What am I doing wrong? Also, I need to have it be Flash, it’s the current player I have, sorry.