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
i obtain message
i have message , don't solution
thanks help.
philippe
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
Post a Comment