CodeIgniter Forums
Affected-rows question - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Affected-rows question (/thread-16288.html)



Affected-rows question - El Forum - 03-02-2009

[eluser]Las3r[/eluser]
Hi there,

I got the following function:

Code:
function submit_ticket($category,$title,$content)
    {
        $db1 = $this->load->database('web', TRUE);
                
        $sql = 'INSERT INTO support_tickets
                (sender,category,ticket_title,ticket_contents,date,last_edit,is_answered)
                VALUES
                (?,?,?,?, GETDATE() , GETDATE() ,?) ';

        $submit = $db1->query($sql,array($_SESSION['username'],$category,$title,$content,0));
        if ($sql->affected_rows() == 1)
        {
        echo 'yay';
        return TRUE;
        }
        else
        {
        echo 'meh';
        return FALSE;
        }
}

The query is executed properly, data gets written in the database, however the affected rows won't show properly (should 1, since its an insert statement). I tried changing:

Code:
if ($sql->affected_rows() == 1)
to :
Code:
if ($submit->affected_rows() == 1)
and
Code:
if ($db1->$submit->affected_rows() == 1)


All without result.

Probably something small, can anyone shed some light on this?

Thanks.


Affected-rows question - El Forum - 03-02-2009

[eluser]pistolPete[/eluser]
The user guide tells you how it's working:
Code:
$this->db->affected_rows()

In your case:

Code:
$db1->affected_rows()



Affected-rows question - El Forum - 03-02-2009

[eluser]Las3r[/eluser]
Thanks pete, that's right.

I guess php-ing too much sometimes clouds the min. I tried a bit too much i guess ^^ !

Thanks.