mysql INSERT INTO
#1

Hi,

Using %e in INSERT INTO query gives me e string in database what a ? i write a normal test
Reply
#2

%e is like %s but %e automaticly escape your string to avoid sql injections
Reply
#3

I know that but i say that when i use %e the string is not normal...
Reply
#4

When player enter a string and you want send it to db
For example
Register dialog
Change password
Or for example edit email
Somthing like this
Reply
#5

Read what i write.. All is well, but in database text what i write is 'e' but i write a normal text with %s is everything normal..
Reply
#6

Can you show the query?
Do you use the "mysql_format" or the normal "format" provided by PAWN?

Also, with which variable-type is your column defined in MySQL?
For strings, just use varchar type fields.
Reply
#7

I just changed %s to %e and then not normal things start to write.. I change to %s everything is well. For update queries, select all is well. I use mysql_tquery
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)