Problem while execute the Query

[sujithfem]

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], Language is PHP, i have enclosed the function which make me hazard …….

 

 

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 used 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 the same.

[conker87]

You could try putting backquotes around the %s (`)

[rameshfaj]

try with using the tilde sign and if after using the tilde sign(`fieldname`),then tell us what will happen.

But using the english name will be more easy and readable also isnt it?