Coding help

[RON_ron]

I'm unable to update the table. Could someone tell me why?

 

$dfield1 = mysql_real_escape_string($field1);
$dfield2 = mysql_real_escape_string($field2);
$dfield3 = mysql_real_escape_string($field3);
$dfield4 = mysql_real_escape_string($field4);

$result =sprintf("SELECT * FROM db1 WHERE username ='%s'", $dfield1);
$resultf = mysql_query($result);
if (mysql_num_rows ($resultf) > 0){
$register = "&err=Not Available. Retry.";
echo($register);
} else {

mysql_query("INSERT INTO db1 (name, birthday, street, phone) VALUES ('$dfield1', '$dfield2', '$dfield3', '$dfield4')");
$register = "Successful.";
echo($register);
}

[trq]

You seriously need to learn some debugging and manual reading skills. Your posting lots of questions and learning nothing from the answers.

 

On top of that you really should learn some communication skills. You have not provided anywhere near enough information for anyone to be able to assist you. You are seriously verging on trolling.

[RON_ron]

You seriously need to learn some debugging and manual reading skills

Accepted.

 

and learning nothing from the answers.

What are you referring to?

 

You have not provided anywhere near enough information

My question was "I'm unable to update the table. Could someone tell me why?"

Basically when i use this code it doesn't update the mysql db.

 

in addition.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting T_VARIABLE or '$' in /home/.../test.php on line 5