Syntax Error..

[Thomas001]

This isn't getting put into the database, maybe it's because of a syntax error.. I'm not getting any error messages:


$creation = "INSERT INTO $uber_table ( `subject` , `comment` , `modif_sc` , `name` , `type`, `date` )
VALUES ('$subject', '$comment', '$modif_sc', '$name', '$type', NOW( ) )";


mysql_query($creation);

 

[cLFlaVA]

You should return a value from the call to mysql_query. In other words,

$result = mysql_query($creation);

Then, you'll be able to determine more easily what the problem may be:

$result = mysql_query($creation);
if (!$result) {
echo mysql_error, "<br>";
} else {
echo "successfully added row.";
}

Let me know what that error message says...

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[cLFlaVA]

*correction...

echo mysql_error(), "<br>";

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[Thomas001]

nm modif_sc was suppose to be sc


=) =) =)