0

Hi
Could anyone help me with this problem, I am trying to use php to insert user record into table (tblusers) using mysql command but I do get this error (Parse error: parse error, unexpected ';' in register.php on line 30 ) I don’t know what is wrong with it any help will be highly appreciated.
Kind Regards
HB25
The could I am using on line 30 is :

$query = "INSERT INTO `".$conf['sql_tbprefix']."tblusers` (`Username`,`Password`,`firstname`,`surname`,`address1`,`address2`,`town`,`postcode`,`telephone`,`email`) VALUES('".mysql_real_escape_string($username)."','".md5(mysql_real_escape_string($password))."', '".mysql_real_escape_string($address1)."', '".mysql_real_escape_string($address2)."', '".mysql_real_escape_string($town)."', '".mysql_real_escape_string($postcode)."', '".mysql_real_escape_string($telephone)."', '".mysql_real_escape_string($email)."')";
3
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by Lizapotter
0

This error comes due to some problem in the syntax of query, divide your query into small pieces means just try to enter data first for one field only and also check the comma and inverted commas you are using are correct

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.