Code:
SELECT COUNT(*) AS NumberOfRows FROM a_poll_votes WHERE QUESTION_ID='1' AND DATE_SUB(CURDATE(),INTERVAL 0 DAY) <= DATE_FORMAT(DT, '%Y-%m-%d') AND IP='111.111.1.1'
DATE_SUB(CURDAT E(),INTERVAL 0 DAY) <= DATE_FORMAT(DT, '%Y-%m-%d')
Can anbody plz help me.
This needs to be in asp and mssql
Thanks
Comment