Dumb error i cant fix

ps2gamer

i cant figure this one out, why wont it add to the database it doesnt give me an error so i figured i had the db info wrong, but its right! I have it connecting to the db farther up in the code and it works fine.


$added = date("M d, Y");

$sql = "INSERT INTO mainnews (title,desc,body,added,userid)
VALUES ('$title', '$desc', '$body', '$added', '$userid')";
$result = mysql_query($sql);

rpanning

Few things to make sure..
1. Make sure your database connection is still open, should even pass it into the mysql_query($sql, $db_connection);
2. Make sure all of the variables your using are set, print each one.
3. Check your SQL command, I think it IS case sensitive. DB name is correct and field names are correct.

ps2gamer

ok i double checked everything like you said but i have no luck still

but if i try just inserting title by itself, it works perfectly.

rpanning

Originally posted by ps2gamer
ok i double checked everything like you said but i have no luck still

but if i try just inserting title by itself, it works perfectly.

Humm...I'm not much of a database persion yet but is that added field a date format in the database? If so I think you need to format your date differently like date("Y/M/d") I think. Does the query return an error/false?

nemonoman

$sql = "INSERT INTO mainnews (title,desc,body,added,userid)
VALUES ('$title', '$desc', '$body', '$added', '$userid')";

$result = mysql_query($sql);

//use this debug code:

$err=mysql_err($result);
$errno=mysql_errno($result);

echo "$sql<BR>$err<BR>$errno";

You may be having trouble adding the date, which requires a different format than M d Y

try using the SQL current_date() function instead, which always works:

$sql = "INSERT INTO mainnews (title,desc,body,added,userid)
VALUES ('$title', '$desc', '$body', current_date(), '$userid')";

rpanning

Originally posted by nemonoman
You may be having trouble adding the date, which requires a different format than M d Y

try using the SQL current_date() function instead, which always works:

Exactly, I also think DATE() works as well. Ex: $sql = "INSERT INTO mainnews (title,desc,body,added,userid) VALUES ('$title', '$desc', '$body', DATE(), '$userid')";