Strange Error on working PHP

[Entourage]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in www/htdocs/test/admin/db_mysql.php on line 154

PHP Code:

$currenthits=$DB_site->query_first("SELECT hits FROM main WHERE id=1");
$negertje=$currenthits['hits'] + 1;
$DB_site->query_first("UPDATE main SET hits=$negertje WHERE id=1"); 


TABLE main (
hits int(10) NOT NULL default '0',
id tinyint(4) NOT NULL default '1'
) TYPE=MyISAM;

It all works but gives that stupid error :/ why o why?

[DrkFusion]

Ah Yes, I get this same error, are you running on a server with Ensim Administration?

-nOX

[Velocd]

The error is probably caused because you are using query_first instead of query. Also, this method would be easier and save you a query:

PHP Code:

$DB_site->query("UPDATE main SET hits=hits+1 WHERE id=1"); 


[Xenon]

if you run queries with no output you can't use query_first, just use query.
Because query_first is a call of query and then uses fetch_array once.

so correct it would be:

PHP Code:

$currenthits=$DB_site->query_first("SELECT hits FROM main WHERE id=1");
$negertje=$currenthits['hits'] + 1;
$DB_site->query("UPDATE main SET hits=$negertje WHERE id=1"); 


and if you don't need your $negertje and currenthits values anymore you can save a query by doing just this:

PHP Code:

$DB_site->query("UPDATE main SET hits=hits+1 WHERE id=1"); 


[DrkFusion]

Yes, but Ensim has some sort of universal problem, with this fetch_array thing, its a continued problem for me as well.

-Arunan

[DrkFusion]

I get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site19/fst/var/www/html/support/admin/db_mysql.php on line 149

[DrkFusion]

Here is the php

PHP Code:

if ($string!="") {
      $condition.=" AND linkname LIKE '%".addslashes($string)."%' OR linkdesc LIKE '%".addslashes($string)."%'";
    }

$search=$DB_site->query_first("SELECT linkid,catagoryid,linkname,linkdesc FROM gportal_weblinkslink ORDER BY linkname");

while ($results=$DB_site->fetch_array($search)) {
    $linkid = $results['linkid'];
    $linkname = $results['linkname'];
    $linkdesc = $results['linkdesc'];
    $hits = $results['hits'];

 eval("\$resultbits .= \"".gettemplate("drkslinks_linkbit")."\";");
}

eval("\$navigation = \"".gettemplate("drkslinks_navigation")."\";");
eval("dooutput(\"".gettemplate('drkslinks_searchresults')."\");");; 


[Xenon]

arunan: also you have to cut out the _first of your query call..

you cannot use fetch_array with query_first
the outputtype of query is a mysql result, this is what you can use in fetch_array.
the outputtype of query_first is just a normal array not a mysql result so you can't use it with fetch_array

[DrkFusion]

Thanks Xenon, worked great!

-Arunan

[DrkFusion]

Hey Xenon, the stuff are getting listed, but they all get listed now, not just the ones with the key words :'(