We have a little problem here. We I queried with the SQL Query from the "Write Query" button.
PhpMyAdmin returned:
SQL query:
SELECT @ maximo: = MAX (entry) +1
FROM accounts;
MySQL returned
# 1054 - Unknown column 'entry' in 'field list'
I don't think that the mySQL server likes the query var
It seems that it will not cooperate with mySQL ver. 5.1.41
PHP Code:
!--SELECT @maximo := MAX(entry) + 1
Also do that all things that you insert into the table ATLEAST: "`login`, `password` and `gm`" is stringed with
PHP Code:
'Single Quotes'
Example
PHP Code:
SELECT * FROM accounts;INSERT INTO `accounts` ( `acct` , `login` , `password` , `encrypted_password` , `gm` , `banned` , `lastlogin` , `lastip` , `email` , `flags` , `forceLanguage` , `muted` , `banreason` )
VALUES (1, 'admin', 'admin', 0, 'az', 0, 0, 0, 0, 24, 0, 0, 0)
Else good work, I love it if it weren't for that error.
PS: Haven't figured your variable out that i am new to SQL the thing with the single quotes where a wild guess.
Bookmarks