[RESOLVED] Syntax Error, Unexpected T_Variable on Line 18

Minecraft_iPod

Hi,

I am a TOTAL newbie at PHP, and I am building off a tutorial website. But, to my utter disappointement (:mad🙂 I can't figure out what went wrong with my code. I keep getting this exact error (I took out personal information):

"Parse error: syntax error, unexpected T_VARIABLE in /xxxx/xxxxxxxx/xxxxxx_xxxx/members.php on line 18"

Here is my code (again, without personal information):

<html>
	<head>
		<title> Lego Comic </title>
	</head>
<body> <center>
	<h1> Thank you for joining! Now click <a href="index.php" title="Login"> HERE </a> to login! </h1>

<?php

//Connect to the database server
mysql_connect("xxxxxx.xxxxxxxxxx.xxx","xxxxxxxx_xxxxx","xxxxxxxx") or die (mysql_error ());

//Select database
mysql_select_db("xxxxxxxx_xxxxx") or die (mysql_error ());

//The SQL statement is built by the user, taking information from becomeamember.php
$strSQl = "INSERT INTO Members(firstname) values('" . $_POST["firstname"] . "')"
$strSQL = "INSERT INTO Members(username) values('" . $_POST["username"] . "')"
$strSQL = "INSERT INTO Members(password) values('" . $_POST["password"] . "')"

//The SQL statement is executed
mysql_query($strSQL) or die (mysql_error());


//Close the database connection
mysql_close();
?>

</center> </body>
</html>

Thanks, help would be appreciated. 😕😕😕😕

NogDog

You don't have a semi-colon at the end of the lines where you define $strSQL. Also note that you will need to execute each of those separately via mysql_query(), otherwise you are only going to execute the last-defined one.

Minecraft_iPod

Thank you SO much, you've solved the problem!

dalecosp

Welcome to PHPBuilder!

Glad to see you were helped (Nogdog's like that 😉 )

Thanks also for marking this resolved! You're off to a fine start.

Have a look at "Debugging 101" (linkage in my .sig) for some additional tips that might help. We might get tired of reading about every syntax error you'll likely encounter 😃 (/me knows ... I probably see half a dozen per day on average ... some days MANY more 😉 )