Update query problem

[mattBeck]

Hi I've a problem updating the prestashop database via a query in a php script, the query looks like this

$queryResultUpdateAttribute = mysql_query('
	    UPDATE
            ps_product_attribute
	    SET
		    quantity = ' . $resultQtyAttribute->DisponibilitaVarianteTagliaResult . '
	    WHERE
		    reference = ' . $refAttribute . '
	    ;
        ');

And even without errors the query doesn't succesfully update the database, reference and quantity are passed as strings.

 

 

 

[mattBeck]

I've solved it, the problem was related to the variable type. 

 

I've got another question though, since now the tables are updated but numbers doesn't show up in the BO quantities, any idea why?