update query

[eluser]Georgi Veznev[/eluser]
[quote author="André Padez" date="1289775347"]Hi,

I wish to make something like:

Code:

$query = 'update table set field = value where id = 3';
$result = $this->db->($query);
$count = $result->num_rows(); //should return the number of rows affected by the last query
return $count;

Instead, the only workaround i found is:

$query = 'select * from table where id = 3';
$result = $this->db->($query);
$count = $result->num_rows();
if($count > 0){
$query = 'update table set field = value where id = 3';
$result = $this->db->($query);
}
return $count;

does anyone know how i can use the first form?
Thanx[/quote]


http://ellislab.com/codeigniter/user-gui...lpers.html

Code:

$query = 'update table set field = value where id = 3';
$result = $this->db->($query);
$count = $result->affected_rows(); //should return the number of rows affected by the last query
return $count;