After battling this for more than a couple hours I can't see straight anymore. Can anyone please point out the friggin' obvious mistake I'm making?

PHP Code:

$user= $_SESSION['userid'];
$feed= stripslashes($_GET['fd']);

    $nw_query = "INSERT INTO picks VALUES ('','$feed','$user','')";
    $nw_result= mysql_query($nw_query);
        
if ( ! $nw_query ) {
    mysql_error();
} 


The table that I'm trying to enter these values into is;

pickID int(6) auto increment
pickFeed varchar(200) null
userID int(6) null
pickDate datetime null

Cheers.

If you have a default value on a field, don't try to override it with an empty value, especially on your primary key...

INSERT INTO picks (pickFeed, userId) VALUES ('$feed','$user');

I wonder why you put default values to null, and try to assign them an empty value ?
Take care, '' != null.
null means no value, '' means an empty value, which is not null.

I would assume, also, that if you changed:
if ( ! $nw_query ) {
mysql_error();
}

to:
if ( ! $nw_result ) {
echo mysql_error();
}

then you might get that error message to show.

Cheers guys. I've made the changes but still no joy. Plus, the error message isn't being produced.

Any more ideas?

Can you give more code including more php, a desc table on the tables or a run down of the db structure?

Hey guys. Thanx for the help. I've fixed it by doing changing this;

PHP Code:

INSERT INTO picks (pickFeed, userId) VALUES ('$feed','$user'); 


to this

PHP Code:

INSERT INTO picks (pickFeed, userId) VALUES ($feed,'$user'); 


by dropping the '' on the $feed variable. It was producing the $feed variable with double single quotes.

I'll have to admit, I don't understand how that could have worked.
http://www.phpfreaks.com/mysqlref/2.php

Cool. I thought it was just me.

For another problem, that's not completely unrelated, how can i remove the single quotes from the start and end of a string variable? I've been playing around with str_replace, preg_replace and substr_replace but each of them require a replacement string.

All I want to do is remove them completely as in this string;

'http://feeds.feedburner.com/~r/GardeningTipsnIdeas/~3/153206427/7_garden_horror_stories.html'