Re: Fatal error: Call to a member function fetchRow() on a non-object in C:\Xampp\xampp\htdocs...

From: 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 >

« previous php.general (#238636) next »