What im trying to do is to alter a table using some code to put in a php file. I have made the code and when i run it, it dont come up with any errors but dont enter the data into the table. Here is the code I have, can anybody quickly examine it and see where the problem might lie? This part "".$db_prefix."users`" needs to be like that or in some way, what it is doing is taking from another file the db prefix and extend it with users.
$result = dbquery("'ALTER TABLE `".$db_prefix."users` ADD `user_cellphone` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ,'
. ' ADD `user_money` MEDIUMINT( 7 ) DEFAULT \'5000\' NOT NULL ,'
. ' ADD `user_computer` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_energy` SMALLINT( 4 ) DEFAULT \'100\' NOT NULL ;'
. ' ADD `user_food` TINYINT( 3 ) DEFAULT \'50\' NOT NULL ;'
. ' ADD `user_water` TINYINT( 3 ) DEFAULT \'50\' NOT NULL ;'
. ' ADD `user_drink` TINYINT( 3 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_eat` TINYINT( 3 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_age` MEDIUMINT( 5 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_gymvisits` SMALLINT( 3 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_weight` SMALLINT( 130 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_loan` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_loansize` MEDIUMINT( 7 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_cc` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_ccsize` MEDIUMINT( 7 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_minb` MEDIUMINT( 7 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_aib` TINYINT( 1 ) DEFAULT \'0\' NOT NULL ;'
. ' ADD `user_pin` SMALLINT( 4 ) DEFAULT \'0\' NOT NULL ;'
. ' '");
