ok proper weirded out now. its now working, and not sure ive actually changed anything..

this is what is working now:

$query= mysql_query("UPDATE products SET products_quantity = $stock WHERE products_model = $productcode");

will keep you posted if this randomly stops working the same as it started!