Re: Non-Object errors
| From: | Jan G.B. | 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