1
I am building a module and a problem has appeared that I just cant figure out..
On ONE place in my code I do a update query to my database and nothing happens. It doesnt change the info in the database. I get no errors when I turn on the debugs in xoops. Nothing. Everything should work just fine its just that my database isnt updated.
$query = $xoopsDB->query("UPDATE ".$xoopsDB->prefix("my_table") ." SET bla='333' WHERE id='1'");
I am using if, elseif and else to see if I have declared any variable in the file and execute the approperiate section of the code depending on what variable that has been declared.
A note is that it works on all other variables everywhere else in the code, its just THAT row that doesnt work when its called..
if I change the line to:
$query = mysql_query("UPDATE ".$xoopsDB->prefix("my_table") ." SET bla='333' WHERE id='1'");
it works...
Ghaaa!
(using the latest XOOPS version ((not 2.x)) with the latest MySQL version)