itemmarket.php error

[wykydz]

i get this error when you go to the item market

QUERY ERROR: Unknown column 'imQTY' in 'field list'
Query was SELECT im.`imPRICE`,`imQTY`,`imCURRENCY`,`imADDER`,`imID` , i.`itmid`,`itmname`, u.`userid`,`username`, it.`itmtypename` FROM `itemmarket` im LEFT JOIN `items` i ON im.`imITEM` = i.`itmid` LEFT JOIN `users` u ON u.`userid` = im.`imADDER` LEFT JOIN `itemtypes` it ON i.`itmtype` = it.`itmtypeid` ORDER BY i.`itmtype`, i.`itmname`, u.`username` ASC

[CavellA]

O.o go to the database table itemmarket and add in imQTY(int 11)

[Damagedcity.com]

The ` imQTY` field is missing in this case
add this sql in database
[PHP]ALTER TABLE `itemmarket` ADD `imQTY` INT(11) NOT NULL default '0';[PHP]

[rulerofzu]

No dont do that why would you use int(11)???

Are you really EVER going to have that many? Should a player have that many??

mediumint would suffice

[wykydz]

Thank you alot

[CavellA]

No dont do that why would you use int(11)???

Are you really EVER going to have that many? Should a player have that many??

mediumint would suffice

games differ, Ive seen games that have well over billions in qty which is stupid but people do it. default is fine just in case, there is no huge scary risk at using int (11) its just not what you would do which is fine but we gave him the standard fix for his problem.

[rulerofzu]

No huge scary risk well apart from if your game is successful then the difference is quite large.

Standard fix? how so since when was int(11) the default standard?

[rulerofzu]

Well thanks SRB didnt know the default was 10 I just use whats appropriate!

[CavellA]

Ah yea meant 10 lol I knew it was one of them 10 or 11, but yea doesnt really matter if you can secure you code theres no problems either way. Being accurate does leave less room for error and bugs but being smart about the script can be just as good but either way he has multiple answers to try so he should be ok.

[KyleMassacre]

Hmm interesting, I have always used int (11) just cause thats how everything else is unless I just need something with a small reall small value so I just use like tinyint (1) does that work is there something better