I managed to fix that prob thx all.

But now I am having another error

yes.... Well what I am trying to do is have a form which writes into a sql database. The table is called 'subscribe' , and the table has 5 columns which are 1. Clan .2. Website 3.members 4.website 5.accepted (I will fill number five in myself.

The first code for the form is
Code: Select all
<html>
<head>
<align><center><form action=subscribe.php method=post>
<br>
<b><u>Clan Name:</u></b>
<input type=text name=Clan>
<br>
<b><u>Contact Email:</u></b>
<input name="email" type="text" value="">
<br>
<b><u>Clan Members</b></u>
<br>
<textarea name=members></textarea>
<br>
<b><u>Clans Website</b></u>
<br>
<input type=text name=website>
<br>
Please check these details are all correct, and then
<input type=submit value=Submit>
</form>
</html>
</head></center>
Then this page sends the info to subscribe.php , but this is where the error is

.
The error which I get is
Parse error: parse error, unexpected T_VARIABLE in /home/knockou/public_html/subscribe.php on line 18
I don't really know what that means. I kinda guess it has something to do with the $sql in the code below.
The second file, subscribe.php is
Code: Select all
<?
//MySQL Variables. Edit where necessary
$host = "localhost";
$login_name = "knockou";
$password = "XXXX";
//Connecting to MYSQL
MySQL_connect("$host","$login_name","$password");
//Select the database we want to use
MySQL_select_db("knockou_knockout") or die("Could not select database");
$Clan=$_post['Clan'];
$email=$_post['email'];
$members=$_post['members'];
$WEBSITE=$_post['website'];
$sql = "INSERT INTO subscribe SET
Clan="$Clan",
email="$email",
members="$members",
WEBSITE="$website",
");
$result=mysql_query($mysql)
if ($result) {
echo("Thank you, your details have been taken.")
}else{
echo("There was an error.");
}
MySQL_close()
?>
I really wanna get rid of this error

Does anyone know what I should do?
