MySQL query 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
		('bob','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");
?>

I keep getting Unable to execute the Critical MySQL query #1 for no reason. All that should work

[Barand]

When it dies, check the value of mysql_error() instead of your current message

[GroundZeroStudio]

how do i do that?

[Archadian]

die(mysql_error());

[mmarif4u]

<?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
		('bob','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");
?>

I keep getting Unable to execute the Critical MySQL query #1 for no reason. All that should work

 

 

Change this:

('bob','none',none,null,null,null,null,null,none,null,null,null,null,null,'Client','none','no')";

 

To this:

('bob','none','none',null,null,null,null,null,'none',null,null,null,null,null,'Client','none','no')";

 

 

[Jessica]

You can leave out all the null columns.