simple error
#1

why i get this error in mysql_log what is wrong

Код HTML:
[23:55:24 10/07/16] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'StR_Marian a folosit /fly' in 'field list' (Query: "INSERT INTO `*******rfeed` (`Text`,`Date`) VALUES (`StR_Marian a folosit /fly`,`07/10/2016 - 23:55:24`)")
and this is a pic with my structure from `*******rfeed`

http://imgur.com/a/2y8Oa

and the script is

Код HTML:
new *******rfeed[500];
		format(*******rfeed, sizeof(*******rfeed), "%s a folosit /fly", sendername);
		mysql_format(handle, gQuery, sizeof(gQuery), "INSERT INTO `*******rfeed` (`Text`,`Date`) VALUES (`%e`,`%e`)", *******rfeed, GetDate());
		mysql_tquery(handle, gQuery, "", "");
Reply
#2

There is a difference between ` (backtick) and ' (apostrophe). The first denotes an identifier (database, table, column, etc) the second denotes a literal string.
Reply
#3

thx man
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)