[SOLVED] Time and date query plesssssssHelp

[shamsuljewel]

Hello,

I have a table name quiz1 there I have some fields I use a field name time int(11) where I save the time of the users quiz participation. I use time() function to insert it.

 

now I want to execute a query...

 

I need the members who are attent quiz in (current date and before time 9am)  or (previous date after 9am).

 

so hows the query???any help...preferable.

Thanks 

 

 

[Barand]

try

<?php
$time2 = mktime(9,0,0);
$time1 = strtotime('-24 hours', $time2);

$sql = "SELECT some, fields FROM mytable WHERE `time` BETWEEN $time1 AND $time2";

[fenway]

try

<?php
$time2 = mktime(9,0,0);
$time1 = strtotime('-24 hours', $time2);

$sql = "SELECT some, fields FROM mytable WHERE `time` BETWEEN $time1 AND $time2";

MySQL has a STR_TO_DATE() function too...

[Barand]

Thanks, how would I use it for this problem?

[fenway]

Actually, didn't realize it was based on the current time, so it's a bit different:

 

SELECT some, fields FROM mytable WHERE `time` BETWEEN CURDATE()+INTERVAL 9 HOUR AND CURDATE()+INTERVAL 9 HOUR-INTERVAL 1 DAY

 

[shamsuljewel]

thanks all this is great...i do not know strtotime function before...

I have solved my problem.

Anyway thanks again.