Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database problem? MySQL fetch... not a valid MySQL result ??


Guest

Recommended Posts

Posted

:?: :idea: Please, can someone help me get started...

 

:arrow: You can take a look at my site at:

 

http://www.voordeelslapen.nl/admin/default.php

 

and

 

http://www.voordeelslapen.nl/catalog/default.php

 

 

I receive the following error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/domain/voordeel/www/data/admin/includes/functions/database.php on line 39

 

It's produced by database.php;

 

<?

function tep_db_connect() {

global $db_link;

 

if (USE_PCONNECT) @$db_link = mysql_pconnect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD);

else @$db_link = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD);

 

if ($db_link) @mysql_select_db(DB_DATABASE);

return $db_link;

}

 

function tep_db_close() {

global $db_link;

 

$result = mysql_close($db_link);

 

return $result;

}

 

function tep_db_query($db_query) {

global $db_link;

 

if (STORE_DB_TRANSACTIONS) {

error_log("QUERY " . $db_query . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

}

 

$result = mysql_query($db_query, $db_link);

 

if (STORE_DB_TRANSACTIONS) {

$result_error = mysql_error();

error_log("RESULT " . $result . " " . $result_error . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

}

 

return $result;

}

 

function tep_db_fetch_array($db_query) {

 

$result = mysql_fetch_array($db_query);

 

return $result;

}

 

function tep_db_num_rows($db_query) {

 

$result = mysql_num_rows($db_query);

 

return $result;

}

 

function tep_db_data_seek($db_query, $row_number) {

 

$result = mysql_data_seek($db_query, $row_number);

 

return $result;

}

 

function tep_db_insert_id() {

 

$result = mysql_insert_id();

 

return $result;

}

 

function tep_db_free_result($db_query) {

 

$result = mysql_free_result($db_query);

 

return $result;

}

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...