Database help

[nm2002]

When I go to my admin and when I clikc on product category I get this error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site54/fst/var/www/html/oscommerce/admin/includes/functions/database.php on line 99

 

 

here is the database.php

I also pointed out where 99 line is? how can I fix this?

 

$query .= $columns .= ' = null, ';

break;

default:

$query .= $columns . ' = \'' . tep_db_input($value) . '\', ';

break;

}

}

$query = substr($query, 0, -2) . ' where ' . $parameters;

}

 

return tep_db_query($query, $link);

}

 

function tep_db_fetch_array($db_query) {

LINE ------99 return mysql_fetch_array($db_query, MYSQL_ASSOC);

}

 

function tep_db_result($result, $row, $field = '') {

return mysql_result($result, $row, $field);

}

 

function tep_db_num_rows($db_query) {

return mysql_num_rows($db_query);

}

 

function tep_db_data_seek($db_query, $row_number) {

return mysql_data_seek($db_query, $row_number);

}

 

function tep_db_insert_id() {

return mysql_insert_id();

}

 

function tep_db_free_result($db_query) {

return mysql_free_result($db_query);

}

 

function tep_db_fetch_fields($db_query) {

return mysql_fetch_field($db_query);

}

 

function tep_db_output($string) {

return htmlspecialchars($string);

}

 

function tep_db_input($string) {

return addslashes($string);

}

 

function tep_db_prepare_input($string) {

if (is_string($string)) {

return trim(stripslashes($string));

} elseif (is_array($string)) {

reset($string);

while (list($key, $value) = each($string)) {

$string[$key] = tep_db_prepare_input($value);

}

return $string;

} else {

return $string;

}

}

?>

[Guest]

is this a new installation? did you try changing anything in the database itself?

[nm2002]

Here is what happened I modifyed the "categories" file in admin directory and the reason for that is becaouse I donwloaded the "Individual-Ship-v3.1" modulator so that I can enter the price for each product, and I followed the instructions on how to edit, but before I didnt modify the categories file I didnt get that error, can you please help me fix this or if you can follow those instructions and send me the files that need to be modified maybe I made a mistake when I was editing it, Im new at this :o

[Guest]

if the file you modified is categories.php i would definitely start back there and see what you may have done, follow the instructions again.