Parse Error

tyrnt

Where is the parse error on this line of code?
$query = "INSERT INTO $userstable VALUES('$realname', '$username', '$password', '$email', 'n', '$ff3exp')";

i have tweaked it and messed with it all that i can think of.

thank you,

Tyrnt

kgahn

Hi,

[quoted original [...]
$query = "INSERT INTO $userstable VALUES('$realname', '$username', '$password', '$email', 'n', '$ff3exp')";

I think you just have to write INSERT INTO userstable [...] without the $-sign.

If you want to use a variable called $userstable, you should write it "INSERT INTO ".$userstable." VALUES [...]

Anon

I assume you're getting a database error from this line? The most likely cause of the error (from the information you've given) is that one of your variables has a ' (single quote) in it. So when it's parsed and sent to the database, one of your variables looks like 'Parse'error'. You should always use the addslashes() function when inserting into a database. Let me know if this doesn't help.

eric

yelvington

There is no PHP syntax error here, as you can easily demonstrate by pasting your code into a page by itself:

<?
$query = "INSERT INTO $userstable VALUES('$realname', '$username',
'$password', '$email', 'n', '$ff3exp')";

echo $query;
?>

Often a line number of a syntax error is incorrect because the real cause of the error is embedded in a previous line -- an open quote, for example.

Also, Karsten's answer is incorrect. You do not need to disassemble the string into multiple strings and use the concatenation operator. PHP will perform variable substitution on double-quoted strings.

tyrnt

thank you all for your help i really appreciate. I actually should have checked for this before postin because i do know C++ too and it is a common problem. It was a missing semi colon on the previous line. i feel dumb.

Thank you,

--Tyrnt

lordstjohn

That what I thougt... For all of youn you were describing a problem with the Database... For this case you should have a Database Error an not a PHP error !

Yes Sometimes, you have to search before the line of the parse error to fing your error.

Anon

Thank you SO much for missing a semicolon!

I came to this site looking for an answer to the same question, with the same solution!

I don\'t feel so dumb...I feel relieved and enlightened!!

Best regards,
Pam

Anon

I get a parse error too on the sql query but it doesn t seems to be a semicolon error...

I ve tried all solutions with ", ' or \' but nothing...:

<? include ("./info.php3");
mysql_select_db ($db,$cnx);
$sql= "INSERT INTO produits (nom,prix) VALUES ('$nom','$prix')";
$result= mysql_query ($sql, $cnx);
echo "Vos infos on été ajoutées.";
mysql_close();
?>

Need help...

Thx

Anon

AAAARRRRGGG!!!! I fought with this bastard for 4 hours! and found that I was missing a single semicolon!

I will make sure to check my line endings from now on! thanks for the entry.

Jon