[RESOLVED] INSERT not working.. no idea why

[unlucky17]

I think I might put my head through a wall in a second..

So, here's the code:

$current_time = time();

$user_id = $_SESSION['user_id'];

    $subject = "Submission Received!";
    $body = "Hi there!  Thanks for submitting your file.  The administration is going to review your file and we will let you know if it has been selected as a weekly finalist.  Thanks again.  We wish you the best of luck!";
    $from_user = 12;

    mysql_query("INSERT INTO table_name (sent_ts, from_user_id, to_user_id, subject, body)
    VALUES ('" . $current_time . "','" . $from_user . "','" . $user_id . "','" . $subject . "','" . $body . "')");

I have another insert right below that one (inserting in another table) and that insert works fine, so the code is executing. I have an EXACT COPY of this insert in another part of my site (adding a private message), but the variables are $_POST instead of just regular $whatever. The code is exactly the same but for some reason the !#%$ing thing won't save to the table. I literally copied and pasted the code and it works in one spot, but not another. ARGHHH!!!!

[unlucky17]

I should also mention that I have echoed every variable that is being inserted to be sure it's set properly, and they are all set.. it just doesn't work when I try to insert it.

[Weedpacket]

Does MySQL report any errors?

Does it still fail if you just write the query as a single string instead of building it up from variables?

[unlucky17]

I replaced the $user_id variable with $SESSION['user_id'] and for some reason it started working, which doesn't make any sense because I simply set $user_id to equal $SESSION['user_id'] in the first place...

😕

Whatever.