Jump to content

mySQL Interval query giving me trouble


amites

Recommended Posts

Hello,

 

I'm having trouble figuring out why this query isn't working for me

 

SELECT
Count(s.id)
FROM
bil_msg_sent AS s
WHERE
s.created BETWEEN  now() AND now()  - INTERVAL 172 hour
AND s.active =  '1'

 

fairly straight forward, if you'd like I can post database info though I don't think it's needed,

 

any help and.or advice is greatly appreciated

Link to comment
https://forums.phpfreaks.com/topic/94812-mysql-interval-query-giving-me-trouble/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.