4 replies to this topic

[Blimp]

Hi guys,

Iv been making a website for a few days now, but have got to a point where im really stuck. I'm trying to create a file which will register a user. Im getting the error...

Quote

Parse error: syntax error, unexpected T_STRING in /home/a4941674/public_html/register.php on line 17

Here's my code (Im not posting it all for security reasons)

$sql=INSERT INTO  `'$db_name'`.`members` (`id` ,`username` ,`password` ,`email` ,`coins`)VALUES (NULL ,  '$username',  '$password',  '$email',  '0');

$result=mysql_query($sql);

can somebody tell me why i'm getting this error and how to fix it?

Thanks a bunch guys!

[WingedPanther]

It looks like you aren't delimiting the string you are assigning to $sql.

[Blimp]

Does that mean I'v missed out the " before and after the Sql query? If I have, I'm sorry for my mistake!

Thanks.

[Alexander]

You are not storing $sql as a string. Your code:

$sql=INSERT INTO  `'$db_name'`.`members` (`id` ,`username` ,`password` ,`email` ,`coins`)VALUES (NULL ,  '$username',  '$password',  '$email',  '0');
$result=mysql_query($sql);

And fixed -- the SQL contained within a string:

$sql = "INSERT INTO  `$db_name`.`members` (`id` ,`username` ,`password` ,`email` ,`coins`)VALUES (NULL ,  '$username',  '$password',  '$email',  '0')";
$result=mysql_query($sql);

You may use a syntax highlighter to write your code in, it can be handy to show you what are strings and not, so you can verify if you wrote it correctly. You can see by the first code how it appears wrong for example.

[Blimp]

I understand.

Thankyou very much for this reply, it's really helped me!

Kudos for you my friend(: