My db:
CREATE TABLE `tb_event` (
`id` tinyint(4) NOT NULL auto_increment,
`t_date` date default NULL,
`t_event` varchar(75) default NULL,
`t_place` varchar(75) default NULL,
`t_content` text,
PRIMARY KEY (`id`)
)
Records:
1, '2011-01-09', 'event 1', ...
2, '2011-05-12', 'event 2', ...
3, '2011-09-20', 'event 3', ...
-------
My code here:
<?
$now = date("Y-m-d");
...
...
SELECT * FROM tb_acara WHERE t_tanggal >= $now
...
...
?>
It will show all records..
I change >= with <= it didn't show anything
-------
My goal is:
I only want to show the event which in September (month of 9) on record number 3
Can you help me please guys??
Thanks