time interval

[buladex]

i need time restriction of 12 hours for voting system, my code looks like this but doesnt respect 12h interval, some time after time pass 00:00 ppl can vote endless until next day at 12:00:

$sql="SELECT * FROM $tbl_name WHERE DATE_ADD(CURRENT_DATE(), INTERVAL 12 HOUR) > `last_voted`  and name='$myusername'";

 

any suggestion????

i also try CURRENT_TIME() and didn not work

[Ken2k7]

Doesn't make sense because for one, CURRENT_DATE() should be already be greater than last_voted, so adding 12 hours to it doesn't do anything. I think you want to subtract or add 12 hours to last_voted. But your logic is off.

[JAY6390]

$time = time() - 43200;
$sql = "SELECT * FROM `$tbl_name` WHERE `last_voted` > '$time' AND `name` = '$myusername'";

That will return rows of any vote within the last 12 hours (43200 seconds)

[yperevoznikov]

@buladex

Hi. Can you try this (Usage sql is more faster):

$sql="SELECT * FROM $tbl_name WHERE DATE_ADD(NOW(), INTERVAL -12 HOUR) > `last_voted`  and name='$myusername'";

[buladex]

im using sql , and my last_voted is a like this `last_voted` = NOW() table save,  i tried them all above, atm i have it set like this: $sql="SELECT * FROM $tbl_name WHERE DATE_ADD(CURRENT_DATE(), INTERVAL -12 HOUR) > `last_voted`  and name='$myusername'";  works at this time but i need to see later if works cuz i cant change my computer time.

ty all for helping ill let u know later if its working

[buladex]

not good ppl that voted 24 hours are not allowed to vote (

[buladex]

Ken2k7 does this make any logic now??? :

 

 

$sql="SELECT * FROM $tbl_name WHERE DATE_ADD(`last_voted`, INTERVAL 12 HOUR) < CURRENT_DATE()  and name='$myusername'";

[Ken2k7]

Yes, that should work. It's the same concept yperevoznikov posted. It's basic math really. Either you add 12 hours to last_voted or you subtract 12 hours from the current date.

[buladex]

after it passed 12:00 didnt work (

[buladex]

maybe its sql save ... its set on datetime, ill try to make it time but what should i put on sql save 'last_voted"=???? Now()?

[yperevoznikov]

Hi Buladex

 

I one of decisions you may try to convert time to timestamp and then compare time (by using UNIX_TIMESTAMP() function). Or you may try better solution - TIMESTAMPDIFF() function. Something like this:

TIMESTAMPDIFF(HOUR, `your_time`, NOW()) < 12 or ... > 12 depending on what do you want check. Let me know it this is help you if not - post SQL script you used and examples from DB.

 

Thanks.

[buladex]

atm i droped on using time and i do it manualy at 12 h but i need it to make automatic so how does it work to add 12 h in sql and decrease automatic to 0, using time stamp? i mean if u vot u add in sql table +43200 seconnds(12h) what attribute should have the sql table time?timestamp?

[yperevoznikov]

Hi buladex,

That's very strange

As I understand your condition is not working only if pass 12 hours sharp. Did you try to use `<=` `>=` instead `<` `>`?

About your question: You may convert time to timestamp by UNIX_TIMESTAMP() as I said before or set timestamp as type of your field.