need help friend

[shinobi_master2]

hi friend

$get_contacts_bd ="SELECT id, nama, unit, MONTH(tarikh) as month, DAYOFMONTH(tarikh) as date FROM $table_name
WHERE MONTH(tarikh) = MONTH(NOW()) ORDER BY tarikh";

ps: tarikh = date

i have a problem for example in mytable i have this
id,name,unit,tarikh,status
from the sql statement ( above ) it will display :

For this month :
name ( date )

How i want to add something in this sql command that make every name that it status is yes will not being display..

hope the community can help me...i'm new in this field..

[zhabala]

$get_contacts_bd ="SELECT id, nama, unit, MONTH(tarikh) as month, DAYOFMONTH(tarikh) as date FROM $table_name 
WHERE MONTH(tarikh) = MONTH(NOW()) AND status = 'yes' ORDER BY tarikh"; 

or if the status is boolean

$get_contacts_bd ="SELECT id, nama, unit, MONTH(tarikh) as month, DAYOFMONTH(tarikh) as date FROM $table_name 
WHERE MONTH(tarikh) = MONTH(NOW()) AND status ORDER BY tarikh"; 

Zdenek