problem for create column on mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: problem for create column on mysql (/showthread.php?tid=511788)

---

problem for create column on mysql - jcvag44800 - 07.05.2014

Hello,

This is my code for create a new account. (basic information only): http://pastebin.com/mHgC7XFd
The column is create:

But; when I create a secondary account on my server, the column is not created...

Anyone have an idea ?

Regards

---

Re: problem for create column on mysql - iZN - 07.05.2014

Set the id as AUTO_INCREMENT from 0 or 1. Then just use this query.

---

Re: problem for create column on mysql - Konstantinos - 07.05.2014

Escape the strings otherwise you might be victim of SQL Injection. Also a suggestion: use the latest version of the mysql plugin + threaded queries.

---

Re: problem for create column on mysql - UnknownGamer - 07.05.2014

What version of MySQL Are you using? If your using the MySQL R38 by BlueG, you can just use "%e", for MySQL Escape String.

I learnt this from Misiur!, When we was working at Raven SQL.

Other wise, just use, "mysql_real_escape_string(mysql_query());".

Hope this helped!

---