PHP Not updating database

PHP
1

Hi people,

I’ve got a few lines of code that check a user’s id, then update a field in the database to ‘1’. Unfortunately its not working and wondering if someone can help troubleshoot:

Part 1 (in confirmaccount.php)

$this->usersmodel->updatePremiumCC($account["id"]);

Part 2 (in usermodel.php)

public function updatePremiumCC($userid)
    {
        $sql = "UPDATE users SET ccdetails = '1' AND featured = '1' WHERE id = $userid";
        $this->db->query($sql);
    }

Cheers

2

The code looks fine (sorta), do you receive any errors? What framework are you using? CodeIgniter ?

3

Hi Anthony,

Yep using the codeigniter framework. There are no errors shown either in logs or on screen. I’ve also made sure I have error messages on:

error_reporting(E_ALL); ini_set('display_errors','On');

Is there something I can ‘print’ before the sql query goes off to check the $userid is there or something along those lines?

4

Possibly, try …


log_message('debug', 'Executing: ' . $sql);

Then check your logs. :slight_smile: