TalkPHP - View Single Post

delayedinsanity · 05-01-2008, 05:22 PM

I just ported everything to MySQLi, and everything else works just fine, but for some reason I'm getting wierdness on this query;

PHP Code:


			
$q = sprintf("UPDATE " . TBL_USERS . " SET password='%s' WHERE username='%s'", $szPassword, $szUsername);

$result = $this->mysqli->query($q);

        

echo $result->affected_rows;

die;

The die is in there to debug it... I'm getting this error;

Notice: Trying to get property of non-object in...

$result should be an object. It is in every other mysqli->query I do. Why isn't it here? The query works, it does what it's supposed to do, it just doesn't return $result like it's supposed to. I'm lost.
-m

05-01-2008, 05:22 PM	#1 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	MySQLi wierdness? I just ported everything to MySQLi, and everything else works just fine, but for some reason I'm getting wierdness on this query; PHP Code: `$q = sprintf("UPDATE " . TBL_USERS . " SET password='%s' WHERE username='%s'", $szPassword, $szUsername); $result = $this->mysqli->query($q); echo $result->affected_rows; die;` The die is in there to debug it... I'm getting this error; `Notice: Trying to get property of non-object in...` $result should be an object. It is in every other mysqli->query I do. Why isn't it here? The query works, it does what it's supposed to do, it just doesn't return $result like it's supposed to. I'm lost. -m