need help friend

[shinobi_master2]

hi ,

$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

For example in my table i have

id,name,tarikh,status

ok

From sql command i display this :

Display Data :
Name ( Date )

if to make every data that have status = yes will not display

Sorry i'm new and need help...Thk

[nemonoman]

Hi Shinobi. I guess that english is not your first language?

I'm trying to understand your question.

if to make every data that have status = yes will not display

I think you mean:

If a record has status = yes, DON'T SHOW
If a record has status <> yes, DO SHOW

Did I understand?

If so:
$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";