MySQL db Code

[HabboRetroHelper1]

Can someone make me a MySQL code to Run that would add the table USERS, I want to Add age country role pease help

Something like this i found this image on the web

I did try but when i tried registering i got
field 'age' doesn't have a default value

 

[Jerry]

Put value as 0, NULL or an empty string by clicking a column.

 

[HabboRetroHelper1]

Have you got something i can run in SQL plz?

 

[Jerry]

ALTER TABLE `users` ADD `age` VARCHAR(10) NOT NULL;
ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL default 'Hotel User';
ALTER TABLE `users` ADD `country` VARCHAR(55) NOT NULL default 'Unknown';

 

[HabboRetroHelper1]

Right thas fine now
but when i try to fetch from the database it doesnt show my guy on staff

$getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,role,age,country FROM users WHERE rank = '" . $Ranks['id'] . "'");

but when it is

$getMembers = mysql_query("SELECT id,username,motto,look,online,last_online FROM users WHERE rank = '" . $Ranks['id'] . "'");

it shows my guy but obviously it cant pull role age or country any ideas

 

[Jerry]

Replace role with position as I mentioned position in the query.


Sent from my iPhone using Tapatalk

 

[HabboRetroHelper1]

oh lol im such a nub thanks alot jerry