Hi There, some odd DB issues..

[eluser]Noy Gabay[/eluser]
still not doin' the trick..

So, I went all the way to the database/drivers/mysql/mysql_driver, and looked at this (line #137):

Code:

function _execute($sql)
    {
        $sql = $this->_prep_query($sql);
        return @mysql_query($sql, $this->conn_id);
    }

When I echo the $sql, it looks fine. Works well as SQL input in phpMyAdmin.

The weird thing is, that if I take the echoed string (value of $sql) and put it instead of the variable, like this:

Code:

return @mysql_query("UPDATE `sitewide` SET `Title` = 'Title Title', `Content` = 'Content Content' WHERE `ID` = 1 ", $this->conn_id);

It updates the DB!

I'm not even sure how to debug such a thing..