james6612

can anyone help please

i need help with useing one table to count another tables enteries

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 .