DaniWeb Forum Index > Web Development > PHP

Problem execute the Query

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2007

Posts: 9

Reputation: sujithfem is an unknown quantity at this point

Solved Threads: 0

sujithfem

Offline

Newbie Poster

Problem execute the Query

Apr 22nd, 2008

Hi,
I have a problem especially executing the query, I hope the problem due to special Character, i am using the ADOB for DB[MYSQL], Script is PHP, i have enclosed the function which make me hazard …….

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
 
define('QRY_ALTER_CATEGORY',        'ALTER TABLE Category ADD %s');
 
 function ChangeCategory($FieldName) {
       $Condition = $FieldName.' VARCHAR(20)';
       $Query = sprintf(QRY_ALTER_CATEGORY,$Condition);
       $this->core->DBConn->Execute($Query);
    }
 

define('QRY_ALTER_CATEGORY',        'ALTER TABLE Category ADD %s');

 function ChangeCategory($FieldName) {
       $Condition = $FieldName.' VARCHAR(20)';
       $Query = sprintf(QRY_ALTER_CATEGORY,$Condition);
       $this->core->DBConn->Execute($Query);
    }

The above Function use to Alter the Table Field name ,the problem is : if the Filed name is "Special character [íóÓéèÉÈÚúáàÁÀãñÑÖöÜüßÉ]” means the query is not execute other wise its works well ,please let me know the solution for the problem ,and expecting positive reply and advance thanks for the same .

"The fear of the Lord is the beginning of wisdom"