Re: Fatal error: Call to a member function fetchRow() on a non-object in C:\Xampp\xampp\htdocs...
| From: | Jochem Maas | Date: | Mon, 26 Jun 2006 12:25:23 +0000 |
| Subject: | Re: Fatal error: Call to a member function fetchRow() on a non-object in C:\Xampp\xampp\htdocs... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238636@lists.php.net to get a copy of this message | ||
j.kuehne@sign-tronic.ch wrote:
> Hello
>
> I am pleased if someone could explain me since is wrong the following function call: ($row =
> & $result->fetchRow(DB_FETCHMODE_ASSOC,
> $_SESSION["searchFormVars"]["offset"]+$rowCounter));
> as you will find them on the bottom of the email. By the way, fetchRow() is an object from
> class DB(.php). However mysql_fetch_row() should have same functionality but the argument resp. the
> identity is different. I hardly try to do not mix up functionality from mysql- with db- members.
>
>
> $search = ($_SESSION["searchFormVars"]["search_eb"]);
> $link = mysql_connect("localhost", "root", "040573");
>
> mysql_select_db("knowledge", $link);
>
> $query = setupQuery($_SESSION["searchFormVars"]["search"]);
>
> $result=@mysql_query($query);
>
>
>
>
> for ( $rowCounter = 0;
> ($rowCounter < SEARCH_ROWS) &&
> (( $rowCounter + $_SESSION["searchFormVars"]["offset"]) <
> mysql_num_rows($result)) &&
> ($row = & $result->fetchRow(DB_FETCHMODE_ASSOC,
> $_SESSION["searchFormVars"]["offset"]+$rowCounter));
> $rowCounter++)
> {
$result is not an object. why not lookup in the manual what mysql_query() returns you?
as you have already been told: don't mix mysql_*() function called at random with
calls to what seem to be PEAR DB methods.
problems with PEAR should be directed to the pear specific list btw.
>
>
> Error message:
> Fatal error: Call to a member function fetchRow() on a non-object in
> C:\Xampp\xampp\htdocs\www2\knowledge_db\searchnew.php on line
>
>
> best regards, Georg
>