php mysql sumbit error

[GroundZeroStudio]

<?php
session_start();
$user="*******";
$host="**********";
$password="*********";
$database="**********";

	$connection = mysql_connect($host, $user,$password)
	or die("Couldn't connect to a valid server.");
	$db = mysql_select_db($database, $connection)
	or die("Couldn't select a valid database");
        $sql = "INSERT INTO ClientData2 (LoginName, Discount,ServiceCount,Service1,Service2,Service3,Service4,Service5,CourseCount,Course1,
              Course2,Course3,Course4,Course5,Title,Reviews,Admin) VALUES
		('$newname',"none","none","null","null","null","null","null","none","null","null","null","null","null","Client","none","no")";
	$result = mysql_query($sql)
	or die("Unable to execute the Critical MySQL query #1");
        header("login.php");
?>

 

error:

 

Parse error: syntax error, unexpected T_STRING in /home/.mccoy/wamboldt/ictonentertainment.com/wamboldt/validate.php on line 14

 

What is going on

[Jessica]

The colors of the code give it away - see where you used "none" - that needs to be 'none'. Same for all those ""s

 

Also, you don't need to submit null columns, just leave them out of the query.

[Barand]

Also, you don't need to submit null columns, just leave them out of the query.

 

But if you do include them, do not put quotes around the nulls

 

e.g.

 

VALUES (null, null, null)