How do i select current program from this table

linux1880 · #1 (**permalink**) 08-15-11, 22:16

I am trying to select current program (which is happening now) from this table. Please help Thanks.

Code:

CREATE TABLE `programs` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `p_day` varchar(20) NOT NULL,
 `program` varchar(255) NOT NULL,
 `p_start` time NOT NULL DEFAULT '00:00:00',
 `p_end` time NOT NULL DEFAULT '00:00:00',
 PRIMARY KEY (`id`)
)

Pat Phelan · #2 (**permalink**) 08-15-11, 23:23

What determines the "current-ness" for your purposes?

-PatP

r937 · #3 (**permalink**) 08-16-11, 05:24

Code:

SELECT p_p.id 
     , p_p.p_day 
     , p_p.program 
     , p_p.p_start 
     , p_p.p_end 
  FROM programs AS p_p 
 WHERE p_p.p_day = DATE_FORMAT(CURRENT_DATE,'%W)
   AND CURRENT_TIME BETWEEN p_p.p_start AND p_p.p_end

Internet Services

Web Development

Digital Marketing

Consumer Tech