[RESOLVED] Yet, another mysql problem

[Beffic]

So when ever I try to mute a player it always sets the value to '0' instead of 'Yes'.

I even made sure the database was right and the Muted data is set to VARCHAR. So I have no idea how this would happen.

mysql_query("UPDATE Users SET Muted='Yes' AND Reason='$Reason' WHERE UserName='$Name'");

[Bjom]

Me neither, but why not simply use a tinyint field and set 0 / 1 values 0 = 'false' = 'no' and 1 = 'true' = 'yes'? Saves a tiny little bit of diskspace and processing time too.

[Beffic]

Wanted to do something a little more clean. But that works.

Thanks

[Beffic]

Not fixed... I tried changing and it still does the same thing. Any idea?

[Bjom]

Actually tinyint and 0/1 is the cleanest.

The AND is wrong. Sorry should've seen it right away.

Without the AND you can go back to your varchar 'yes' 'no' solution - but I would suggest keeping the tinyint 0/1....

mysql_query("UPDATE Users SET Muted=1, Reason='$Reason' WHERE UserName='$Name'");