Need help making Query for MYSQL

[St4nley]

how do i update a table "users" that has a column allow_trading that is set to 0 for every account, and i would like to set that to 1

also i need a query so that new users are set to 1 automatically, thanks!

edit: i meant that the new users have their column allow_trading set to 1

 

[GarettM]

Why don't you edit the Query for registration o.o?

 

[St4nley]

Why don't you edit the Query for registration o.o?

how?

edit: i fixed all my current users via

UPDATE 'users' SET 'accept_trading' = '1';

now how can i make new users have trading?

 

[GarettM]

edit your registration code. lollz

 

[Sean]

Are you using mysql or mysqli?

 

[St4nley]

Are you using mysql or mysqli?

mysql

 

[Sean]

If you just want all new users to have trading to be 1 - set the default value to 1 in Phpymyadmin

 

[St4nley]

If you just want all new users to have trading to be 1 - set the default value to 1 in Phpymyadmin

navicat my friend, and when i went into design table found that column set it to '1' i hit save and it would fly back to 0.


exact properties are : enum, (length) 0, (decimals) 0, allow null (not checked)

 

[Sean]

navicat my friend, and when i went into design table found that column set it to '1' i hit save and it would fly back to 0.


exact properties are : enum, (length) 0, (decimals) 0, allow null (not checked)

Try doing it in phpmyadmin for this one thing...

 

[St4nley]

Try doing it in phpmyadmin for this one thing...

i dont have xampp... IIS

 

[Sean]

download this:

You must be registered for see links

and upload into your directory, then navigate to it and try it, because if it's jumping you back to 0 it might be an error in the program

 

[St4nley]

download this:

You must be registered for see links

and upload into your directory, then navigate to it and try it, because if it's jumping you back to 0 it might be an error in the program

thanks, im on it now i opened my table but how do i set default xD there is no design table option

EDIT: THANK YOU I FIXED IT

 

[Sean]

Click the database on the left hand side, then click the table underneath it that pops out.
Then click Structure at the top nav bar
Click the checkbox of the one you want to edit
Click edit
Then input a value of 1 into the Default Box