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

[j . kuehne]

Hello 

I am pleased if someone could explain me the behaviour since is wrong the 
following function call: ($row = & $result->fetchRow(DB_FETCHMODE_ASSOC, 
$_SESSION["searchFormVars"]["offset"]+$rowCounter));
as you will find them below. By the way, fetchRow() is a method 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. 

 
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++)
      {   


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 ...

I am not shure that something should be wrong with the $result parameter since 
I have seen it in the PHP declaration and definition, see 
http://de.php.net/mysql_query below. I now that the return value of mysql_query 
is a boolean resp. a resource handler. In any case, I need the fetchRow 
functionality for correct work as listening to the rows on different pages. 




Another shorter possibility to print options of an ENUM as <select>-tag:
<?php
$result=mysql_query('SHOW COLUMNS FROM <your table> WHERE field=\'<you 
column>\'');
while ($row=mysql_fetch_row($result))
{
   foreach(explode("','",substr($row[1],6,-2)) as $v)
   {
     print("<option>$v</option>");
   }
}
?> 




best regards, Georg