Thread: using mysql_real_escape_string()

Hi,
I want to escape any special characters in the input field before inserting the data into mysql tables in C++.
I know we can use

Code:

mysql_real_escape_string()

function, however I am unsure how to use it, can anybody point me to any examples on this, or write me an example regarding what parameters this function takes and how to use this function.
Thanks,
Tewari

http://dev.mysql.com/doc/mysql/en/my...pe-string.html

Code:

const char *from = "What's this";
char *to = new char[(strlen(from) * 2) + 1];
mysql_real_escape_string(&mysql, to, from, strlen(from));