I want to increase the value of the Counter (an integer) by one.
Here is the SQL:
UPDATE `Article` set `Counter` = `Counter` + 1 where `ID` = '12345"
But when I try to use my SQL with SQLQuery(), I get an error: "Couldn't run query: Query was empty"
$sqlQuery = new SQLQuery(); $sqlQuery->sql = "UPDATE `Article_Live` set `Counter` = `Counter` + 1 where `ID` = '". $this->ID ."'"; $sqlQuery->execute();