Problems adding data to rows

[maxf]

Hey all,

First off, I'm a n00b at this. I've just recently been learning PHP for my site.

I'm in the process of making a script that takes user input (which will always come from me because it'll be used to organize client information.) I've been half way successful so far. I can get it to take some of the information and put it into the table, and then my other page can view the table in an actual HTML table.

I'm having a problem getting some of the data to work though. For instance, this code will work to send the data:

$query = "INSERT INTO $table (delk, number, name, date, email, website, targeted, country, profit) VALUES ('deleteme', '$cn', '$xname', '$date', '$xemail', '$xwebsite', '$xtargeting', '$xcountry', '$profit')";
$result = mysql_query($query, $db);

But for whatever reason, if you add another value into there (that's in the table too) it'll stop working. I have around 14 different values that I need to enter for the table, but three or four don't work.
Here's a sample of non-working code:

$query = "INSERT INTO $table (delk, number, name, date, email, website, targeted, country, username, password, profit) VALUES 'deleteme', '$cn', '$xname', '$date', '$xemail', '$xwebsite', '$xtargeting', '$xcountry', '$xusername', '$xusername', '$profit')";
$result = mysql_query($query, $db);

(the username is the same as the password)

So... any ideas? :rolleyes:

[tekky]

try replacing date with date its a reserved word therefor its probably erroring (you can find out for sure by adding

OR die('error: ' . mysql_error()); after your query....

$result = mysql_query($query, $db) OR die('error: ' . mysql_error());

then you will see the error displayed 😉

[dnast]

There's a ( missing after VALUES

$query = "INSERT INTO $table (delk, number, name, date, email, website, targeted, country, username, password, profit) VALUES color=red";
$result = mysql_query($query, $db);