Insert into MYSQL Error ( Incorrect integer value )??

[emma57573]

This line of script is old, I have made no changes to it in the past few days yet today it decided to stop working! I have no idea what the cause is I checked everything.

 

But I get this error

mysql_query("INSERT INTO mytable(pid,seller_user_id,buyer_user_id,get_date,buy_price,aid,shipping_price,combine_shipping_price,worldwide_shipping,worldwide_combine_shipping,quantity,to_pay)
VALUES('$user_id','$uid','$userid','".date("YmdHis",time())."','$buy_price','','$shipping_price','$combine_shipping_price','$worldwide_shipping','$worldwide_combine_shipping','$qty','1')") 
or die(mysql_error());  

 

This throws up this error;

 

Incorrect integer value: '' for column 'buyer_user_id' at row 1

 

What does this mean?

 

I looked up that it might be a bug but It WAS working and as I said i havnt changed anything so its really odd. Im desperate to get this working! But im just clueless and what the error means.

 

 

[rhodesa]

it means $userid doesn't have an integer value in it. it's empty in fact

[emma57573]

Hum ok I wonder why.... I may be posting again soon.... thanks

[revraz]

These are going to come back and bite you when you go to troubleshoot

 

'$user_id','$uid','$userid',

 

Use something that makes them different.