Zikula Community

• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 275

  Posted: Sep 16, 2002 - 07:56 PM

  Getting a "Supplied argument is not a valid MySQL result resource" from
  a theme I am working with. The lines cited is the one with mysql_fetch_row
  in it, below.
  
  
  echo "<select name="\"topic\"onChange='submit()'">\n"
  ."<option value="\"\"">"._ALLTOPICS."</option>\n";
  while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
  if ($topicid==$topic) { $sel = "selected "; }
  echo "<option value="\"$topicid\"">$topics</option>\n";
  $sel = "";
  
  According to a May 2002 note at php.net,
  "mysql_fetch_row($resultset,MYSQL_ASSOC) no longer works"
  
  It recommends the following type of syntax.
  
  $row=mysql_fetch_assoc($resultset);
  or
  $row=mysql_fetch_array($resultset,MYSQL_ASSOC);
  
  
  I tried changing the mysql_fetch_row in the theme
  to these, but the error remains...
  
  any hints would be most appreciated.
  
  BTW,
  _if_ this mysql_fetch_row is causing problems,
  it would need to be changed in quite a few themes,
  it would seem. Grepping through some theme
  directories gives quite a few hits.
  
  Thanks.</select>

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 275

  Posted: Sep 28, 2002 - 11:34 PM

  this problem with the old themes also
  seems to be the problem with pnglossary.
  old mysql commands in the code need
  to be adjusted.
  perhaps there is a standard rule-of-thumb
  for this line of code?

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.