/**
<br> * Increase or decrease the value of a given field
<br> */
<br>public function increment($update_id, $field, int $value = 1, $target_tbl = null)
<br> {
<br> if (!isset($target_tbl)) {
<br> $target_tbl = $this-&gt;get_table_from_url();
<br> }
<br>
<br> $value = intval($value);
<br> $sql = &quot;UPDATE `$target_tbl` SET `$field` = `$field` + $value WHERE `$target_tbl`.`id` = :id&quot;;
<br>
<br> $data['id'] = (int) $update_id;
<br> $data = $data;
<br>
<br> if ($this-&gt;debug == true) {
<br> $query_to_execute = $this-&gt;show_query($sql, $data, $this-&gt;query_caveat);
<br> }
<br>
<br> $this-&gt;prepare_and_execute($sql, $data);
<br> }

$sql = 'SELECT posts.*, users.username
<br> FROM `posts`
<br> LEFT JOIN `users`
<br> ON posts.user_id = users.id
<br> ORDER BY posts.id DESC';
<br>$posts = $this-&gt;model-&gt;query($sql, 'object');

//$member_id = SOME_CODE_TO_GET_ID;
<br>$params = array('member_id' = &gt;$member_id);
<br>$sql = &quot;UPDATE `members` SET `votes`= `votes`+1, `updated_at` = NOW() WHERE `id` = :member_id LIMIT 1&quot;;
<br>$this-&gt;model-&gt;query_bind($sql, $params);