[__md__]

Does anyone have knowledge of my sql php flash integration?

[Nico]

Vague questions like this are not going to get you any useful answers.

[__md__]

sorry basically I am creating a user registration which is displayed in flash and is linked with mysql database and php files , when I run the swf file I do not get the feedback im supposed to get telling me I am now regged the code on the flash buttons(actionscript) have no errors so it maybe something to do with the mysql database but I have no idea what it could be....

[wirehopper]

Please post your code.

[__md__]

thank you

this is the code for the flash(actionscript) login button

Code:

on (release) {
if (username != "" && pass != "") {
	loadVariablesNum("login.php", 0, "POST");
	words="Processing..."
           }else{
    _root.words = "Please enter a username and password";
	       }
}

the is the code for the register flash (actionscript) button

Code:

on (release) {
     if(username.length >= 6 && pass.length >= 6){
		loadVariablesNum("register.php", 0, "POST");
		words="Processing..."
		
	 }else{
		_root.words = "Username must have between 6 and 12 characters.";
	}
}

the register php file

PHP Code:

<?php 

mysql_connect("localhost","root","") or die(); 

mysql_select_db("dm") or die();  



$usercheck = $_POST['username'];

$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'") 

or die();



$check2 = mysql_num_rows($check);

if ($check2 != 0) {

print "words=Username already exists.&checklog=1";

die();

}



$insert = "INSERT INTO users3 (username, password)

VALUES ('".$_POST['username']."', '".$_POST['pass']."')";

$add_member = mysql_query($insert);

print "words=You are registered.&checklog=2";

die();

?>



the login php file



<?php 

mysql_connect("localhost","root","") or die(); 

mysql_select_db("rr") or die(); 



$check = mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")or die();



$check2 = mysql_num_rows($check);

if ($check2 == 0) {

print "words=User doesn't exist.&checklog=3";

die();

}

while($info = mysql_fetch_array( $check )) 

{



if ($_POST['pass'] != $info['password']) {

print "words=Incorrect Password.&checklog=4";

die();

}else 

{ 

print "words=You are logged in.&checklog=5";

die();

} 

} 



?>

and if its any help the tutorial which i got it from
Flash Kit, A Flash Developer Resource for Macromedia Flash 8 and MX Tutorials SWF FLA images clipart Sounds WAVS Animations Help and Support

[wirehopper]

Put a message in the die() calls - such as die('Could not connect'), die('Could not select').

That will help you see where the problem is.

[__md__]

nope still did not make a difference

[wirehopper]

What did it do?

If I were you, I'd put an echo after every statement until I could identify the line that was causing the script to fail.