help with php my sql

[james6612]

hi basically i have a text based mafia game and in my database i have a table called statis with 2 columns one called alive and one called allof , what i need is table statis column allof to count all enteries in table users and alive to count all my dead users in table users you can tell dead or alive by column status whitch can be dead or alive can anyone help me please .

Edited February 27, 2014 by james6612

[justsomeguy]

Why store those values in a table instead of calculating them when you need to? If the status column is an index then it will be quick to count on demand.