Re: Non-Object errors

From: Date: Tue, 28 Apr 2009 16:23:13 +0000
Subject: Re: Non-Object errors
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-292086@lists.php.net to get a copy of this message
2009/4/28 Miller, Terion <tmiller@springfi.gannett.com>: > Can someone help with how to make this work, trying to get the number of > rows but am getting the "trying to get property of non-object" > > Code----------------- > > $query = "select blah, blah, blah from table where ".$type." like > '%".$name."%'"; > > $result = mysql_query($query); > > $num_results = $result->num_rows; <---------------this is the line with > error > Hi Terion, you're mixing normal mysql_* with mysqli. Mysqli is object oriented and the mormalö mysql_ functions aren't - thei're procedural. So you can do it either like $result = mysql_query("SELECT 1"); $num = mysql_num_rows($result); Or in OOP $res = $mysqlObj->query("SELECT 1"); // $mysqlObj should be initialized first ;) hint: new mysqli() $num = $res->num_rows(); Check ot this URL: http://php.net/mysqli byebye

« previous php.general (#292086) next »