problem for create column on mysql
#1

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
Reply
#2

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

PHP код:
INSERT INTO players (Name,PasswordVALUES ('%s','%s'
Reply
#3

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

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!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)