1054 Unknown column '$var - Joomla! Forum - community, help and support


hello,

i looking solution error 1054 when want update getdbo

first, have several var $var

my script

code: select all

$db = jfactory::getdbo();
 $query = $db->getquery(true);
 
//fields update
$champs = array(
$db->quotename('last_name') . ' =  $name1',
$db->quotename('first_name') . ' = $prename1',
$db->quotename('phone_1') . ' = $tel2',
);
 
// conditions updating
$conditions = array(
    $db->quotename('xxxx') . ' = $id1',
);
 
$query->update($db->quotename('xxxx'))->set($champs)->where($conditions);
 
$db->setquery($query);
$result = $db->execute();



i obtain message
1054 unknown column '$id1' in 'where clause' sql=update



i have message , don't solution

thanks help.

philippe

my problem virtuemart in joomla !!!





Comments

Popular posts from this blog

Upgrade 3.4.8 to 3.5.1 failed "download package failed" - Joomla! Forum - community, help and support

Joomal 3.6.3 update error - PHP temporary folder is not set - Joomla! Forum - community, help and support

Fatal error during instalation - Joomla! Forum - community, help and support