[benel1]

this is my code:

pawn Код:

stock WriteLog(sqlserver, const log[])
{
    new date[3], time[3], string[450];
    getdate(date[0], date[1], date[2]);
    gettime(time[0], time[1], time[2]);
    format(string, sizeof string, "CREATE TABLE IF NOT EXISTS `%02d/%02d/%04d` (`ID` INT(11) NOT NULL auto_increment, `text` varchar(255) NOT NULL default '', PRIMARY KEY (`ID`));", date[2], date[1], date[0]);
    format(string, sizeof string, "%s INSERT INTO `%02d/%02d/%04d` SET `text` = '[%02d:%02d:%02d] %s'", string, date[2], date[1], date[0], time[0], time[1], time[2], log);
    return print(string), mysql_tquery(sqlserver, string);
}

output:

pawn Код:

CREATE TABLE IF NOT EXISTS `06/02/2015` (`ID` INT(11) NOT NULL auto_increment, `text` varchar(255) NOT NULL default '', PRIMARY KEY (`ID`)); INSERT INTO `06/02/2015` SET `text` = '[23:57:55] sgs'

mysql log:

pawn Код:

[23:57:55] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prטs de 'INSERT INTO `06/02/2015` SET `text` = '[23:57:55] sgs'' א la ligne 1

but in phpMyAdmin it show me success
what's the problem?