Hi Guys,
I'm in the process of creating a Flash/PHP/MySQL chat room.
So far I have created an input box on frame one of my movie were the user puts in a name to be used in the chat room. Upon pressing a button the users name will be checked for avaliability within the MySQL database, if it is free then they will be taken to the chat area (frame 2).
After checking the database and before been sent to the chat room, if the user name is not avaliable i want a results message to be displayed in a dynamic text box in frame 1, under the user name input box.
Can anyone tell me how to do this?
The current code for the php file looks like this:
<?
$Connect = mysql_connect('localhost', 'username', 'password');
@mysql_select_db("login");
#Preforms the SQL query
$query = "INSERT INTO user (name) VALUES('$nickname')";
$result = mysql_query($query);
?>
Were would i place the query and how would i then post a results message to the flash movie?
Any advice appreciated,
micmac
