22972 Posts in 11596 Topics by 2824 members
|Go to End|
8 April 2011 at 7:03am
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 ."'";
11 April 2011 at 10:18pm
how about DB::query(); instead?
12 April 2011 at 12:21am
That works, thanks.
|Go to Top|