Hello everyone, this problem:

There is a code:

$db2 = JFactory::getDbo(); $db2->setQuery('update #__virtuemart_orders set '.$row.' =' .$Data.' where virtuemart_order_id='.$virtuemart_order_id); $db2->query();

If we write numbers to the base, then everything is in order, and if the letters and numbers or just letters, then nothing is written down. The database has the varchar data type, when executing the request via phpmyadmin everything works fine.

How to be?

  • how do I get furious with these Jumlov names JFactoryDatabsMySQL :: getDboFromHrenZnaetOtkyda - mountpoint

1 answer 1

  $db2 = JFactory::getDbo(); $db2->setQuery('update `#__virtuemart_orders` set '.$db->quoteName($row).' = '.$db->quote($Data).' where `virtuemart_order_id` = '.$db->quote($virtuemart_order_id)); $db2->execute(); // Joomla 3 $db2->query(); // Joomla old