mysql_fetch_field_row
#8

Sorry for dubbel,dubbel post, but i now whats wrong, but how can i fix it?
Query:
Quote:

SELECT skin, Adminlevel, money, bank, level, exp, xpos, ypos, zpos, apos, tut FROM users WHERE name = '%s' LIMIT 1

(%s = the name of the player.)
Error:
Quote:

[20:17:48] CMySQLHandler::Query(SELECT skin, adminlevel, money, bank, level, exp, xpos, ypos, zpos) - An error has occured. (Error ID: 1054, Unknown column 'skin' in 'field list')

Database:
Quote:

CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(225) NOT NULL,
`password` text NOT NULL,
`skin` int(5) NOT NULL DEFAULT '101',
`adminlevel` enum('0','1','2','3','4','5','6','7','1337','1338' ) NOT NULL DEFAULT '0',
`ip` varchar(20) NOT NULL,
`money` int(225) NOT NULL DEFAULT '5000',
`bank` int(225) NOT NULL DEFAULT '2500',
`level` int(10) NOT NULL DEFAULT '1',
`exp` int(10) NOT NULL DEFAULT '0',
`xpos` float NOT NULL DEFAULT '1685.84',
`ypos` float NOT NULL DEFAULT '-2333.34',
`zpos` float NOT NULL DEFAULT '-2.6797',
`apos` float NOT NULL DEFAULT '1.4551',
`tut` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

Reply


Messages In This Thread
mysql_fetch_field_row - by wouter0100 - 21.08.2011, 10:15
Re: mysql_fetch_field_row - by Macluawn - 21.08.2011, 10:21
Re: mysql_fetch_field_row - by Jochemd - 21.08.2011, 10:24
Re: mysql_fetch_field_row - by wouter0100 - 21.08.2011, 10:27
Re: mysql_fetch_field_row - by Macluawn - 21.08.2011, 10:34
Re: mysql_fetch_field_row - by wouter0100 - 21.08.2011, 12:31
Re: mysql_fetch_field_row - by wouter0100 - 21.08.2011, 17:27
Re: mysql_fetch_field_row - by wouter0100 - 21.08.2011, 18:21

Forum Jump:


Users browsing this thread: 1 Guest(s)