I can add phpadsnew, and see the banner, but

[mlsbv]

I can add phpadsnew in theme.php, and see the banner in top of my blog, but give this error:

Code Select Expand


There was an error while processing a database query



when remove my phpadsnew code in theme.php my gallery was worked very good.

[Nibbler]

It's probably changing the database connection. Enable debug mode to get the mysql error message that is caused. Posting the code would also help. You may have to add some code after the ads to re-select the coppermine database.

Code Select Expand

mysql_select_db($CONFIG['dbname'])

It may also be helpful to keep the ads in the same database as coppermine.

[mlsbv]

Code Select Expand



While executing query "SELECT count(*) FROM cpg134_albums as a WHERE category = '0'" on 0

mySQL error: Table 'adver.cpg134_albums' doesn't exist




thanks

[Stramm]

switch from local mode to eg javascript invocation and all should be good

[mlsbv]

switch from local mode to eg javascript invocation and all should be good

no, this isn't way for me. i want use bye PHP.

[Joachim Müller]

Then you'll have to be a PHP coder to accomplish this.

[mlsbv]

Code Select Expand



While executing query "SELECT count(*) FROM cpg134_albums as a WHERE category = '0'" on 0

mySQL error: Table 'adver.cpg134_albums' doesn't exist




thanks

Hi
I using as this code:

Code Select Expand


function banner() {

    if (@include(getenv('DOCUMENT_ROOT').'/ad/phpadsnew.inc.php')) {
        if (!isset($phpAds_context)) $phpAds_context = array();
        $phpAds_raw = view_raw ('', 0, '', '', '0', $phpAds_context);
$return  = $phpAds_raw['html'];
mysql_select_db($CONFIG['gallery']);


    }
return $return;
}



but, still is conflict database

[mlsbv]

Code Select Expand



While executing query "SELECT count(*) FROM cpg134_albums as a WHERE category = '0'" on 0

mySQL error: Table 'adver.cpg134_albums' doesn't exist




thanks

Hi
I using as this code:

Code Select Expand


function banner() {

   if (@include(getenv('DOCUMENT_ROOT').'/ad/phpadsnew.inc.php')) {
       if (!isset($phpAds_context)) $phpAds_context = array();
       $phpAds_raw = view_raw ('', 0, '', '', '0', $phpAds_context);
$return  = $phpAds_raw['html'];
mysql_select_db($CONFIG['gallery']);


   }
return $return;
}



but, still is conflict database

[Stramm]

this will help you
php.net/global

[mlsbv]

Nibbler, please help me.

[Nibbler]

Under

Code Select Expand

function banner() {

add

Code Select Expand

global $CONFIG;

[mlsbv]

Under

Code Select Expand

function banner() {

add

Code Select Expand

global $CONFIG;

Hi, i put

Code Select Expand

global $CONFIG;

in

Code Select Expand

function banner() {
but not worked
please see the my function.

Code Select Expand


mysql_select_db($CONFIG['gallery']);


is corect?

[Nibbler]

No, use the code as I posted it.

Code Select Expand

mysql_select_db($CONFIG['dbname']);

[mlsbv]

No, use the code as I posted it.

Code Select Expand

mysql_select_db($CONFIG['dbname']);

Thanks man.