SQL problem

[CoRnNuB]

i need a bit of help with this im trying to upload these SQLs

ALTER TABLE `users` ADD `mayfair` int(11) NOT NULL default '0';

ALTER TABLE `users` ADD `richmond` int(11) NOT NULL default '0';

ALTER TABLE `users` ADD `sterling` int(11) NOT NULL default '0';

ALTER TABLE `users` ADD `superkings` int(11) NOT NULL default '0';

ALTER TABLE `users` ADD `dollups` int(11) NOT NULL default '0';

ALTER TABLE `users` ADD `smoking` int(11) NOT NULL default '0';

 

and it keeps saying #1146 - Table 'streets1_imaxhome.users' doesn't exist

can sommone help me with this

[Kieran-R]

The users table doest exist.

Try reading the error - It helps alot! Thats the whole point of it displaying the error. Just incase you didn't know.

[bineye]

I'd bet its more to do with having the wrong prefix

[Danny696]

I bet its not. Im guessing hes using PHPMyAdmin, so that will automatically add the prefix, and the SQLS dont contain a prefix. So thats right.

Kierans right, your users table doesn't exist. Try running the installer file that came with mccodes.