Flash-php-mysql

1

hi all (first post :D)

well, i am using the book (foundation php for flash)
to make a registration script.

(background)
my host upgraded their version of php and switched register globals off (no idea if this has any relevance)

right, well i followed the tutorials as far as i can, i have been using flash for a while now, and i am pretty certain that flash is sending the variables that i need it to.

here is the php script which i am using

<? 
// config file 
include('common.php'); 

$link = dbConnect(); 
// search for dupe usernames 
$query = "SELECT * FROM tblMembers WHERE Username='$Username'"; 

if(!mysql_query($query)) { 
	fail("Couldn't search database for duplicates");  
	} 
// if a match was found 
	if (mysql_num_rows($query) != 0 { 

//inform flash of error and quit! 
	fail("Username $Username already registered");  
	} 
	 
//add user 
	$query = "INSERT INTO tblMembers (UserName, Password, Email, Location, Guild, Server, Class) VALUES ('$UserName', '$Password', '$Email', '$Location', '$Guild', '$Server', '$Class')"; 
	 
	if(!mysql_query($query)) { 
		fail("Username $UserName already exists"); 
		 
		//inform flash of success 
		print "&Status=Okay"; 
	//close link to db 
	mysql_close($link);	 
?>

i am a total newbie to php, so any insight on this would be great

at first, i thought that it would be the php which was letting me down. then my brother asked if i could finish off a shoutbox for him, (add the table and php files) followed directly from a perfect tutorial on the web. guess what, nothing is inputted into the database, just like my problem.

i am guessing that the script and tutorial are designed to work with an older version of php. :diss: soooo…

am i right, is there something i can add to make it work?

the php sends an error message back to flash if there are any problems, well, originally it was doing that, but only because i forgot to CHMOD the .php files, well, no error comes up now.