[SOLVED] function problem

[darkfreaks]

mysql_fetch_array not a valid MYSQL resource on line 7

 

 

code:

 

<?php
function fetch($query)
{
include "config.inc.php";
$result=mysql_query($query);
 while ($row = mysql_fetch_array($result)) {//line 7
          $return = $row;
    }
    return $return;
}><

[revraz]

Means your query is failing.

[darkfreaks]

the problem is this is a function designed to grab any query it takes the place of mysql_query and it arrays it too. in the function. it worked before. i dont see why its doing this :-\

[xtopolis]

Means your query is failing.

(not your function)

Change:

$result=mysql_query($query);

to

$result=mysql_query($query) or die(mysql_error());

to see what the error is.

[trq]

Indeed it does. And because you have absolutely no error handling in place you get an ugly error.

 

<?php
function fetch($query) {
  include "config.inc.php";
  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result) == 1) {
      return mysql_fetch_assoc($result);
    } else if (mysql_num_rows($result) > 1) {
      while ($row = mysql_fetch_assoc($result)) {
        $return[] = $row;
      }
      return $return;
    }
    return false;
  }
}

[darkfreaks]

nevermind SOLVED!