amites Posted March 6, 2008 Share Posted March 6, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.