[SOLVED] Syntax error in query

[Phate]

(I'm new to the whole php and php freaks scene, so I wasn't sure if I was supposed to post this here or on the mysql forum)

 

Here's the error I get

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in add.php on line 78

 

Full code: Here

Line 78:

	$query = "INSERT INTO " . $table . " (date, name, website, location, playersfee, maxplayers, level, description) VALUES('$_POST['date']', '$_POST['name']', '$_POST['website']', '$_POST['location']', '$_POST['fee']', '$_POST['maxplayers']', '$_POST['level']', '$_POST['description']')";

 

I'm thinking maybe because the $_POST variables aren't defined yet when I first load the page, it considers it as whitespace, but normally seen it should only be executed when I clicked the add button for the first, because it's in the If(!isset($_POST['add']) Else section.

 

Does anyone see the problem?

Thanks.

[MemphiS]

Try...

<?php
$query = "INSERT INTO ".$table." ( `date` , `name` , `website` , `location` , `playersfee` , `maxplayers` , `level` , `description` )
VALUES (
'".$_POST['date']."', '".$_POST['name']."', '".$_POST['website']."', '".$_POST['location']."', '".$_POST['fee']."', '".$_POST['maxplayers']."', '".$_POST['level']."', '".$_POST['description']."'
)";
?>