figuring hits today from timestamp....

jebster

I have a stats script I wrote, and for each hit the time is recorded to a MySQL database with a time stamp(ex: time of posting this it is 20030730033203). How would I figure out the hits from the current day(not the last 24 hours, but the current day)?

Thanks

tuf-web_co_uk

$sql = "SELECT * from table where time = timestamp()";

jebster

Wouldn't that just give me entries that where made just that second?

tuf-web_co_uk

yes, my bad try

<?
$time = timestamp();
$time = substr($time, 0, 7); // should output 20030730

$sql = "SELECT * from table where time like '".$time."%'";
?>

jebster

I get an undefined function error for timestamp() and I looked it up at php.net and it doesn't exist! 😕 The way I get the time into the database in the first place is with a field in my database called time_date and its properties(or what ever you call that stuff) are timestamp(14) NOT NULL
If that even makes sense.... God I need sleep(its 4:15am).

tuf-web_co_uk

<? 
$time = date("Ymd");

$sql = "SELECT * from table where time like '".$time."%'"; 
?>

jebster

Sweet! Works like a dream! Thanks 🙂

jebster

Nother question 🙂

How would I get only results that had a date that was equal to or less then 7 days ago?

tuf-web_co_uk

<?
$time = date("Ymd"); 
$time = $time - 7;

$sql = "SELECT * from table where time = '".$time."%' AND time > '".$time."%' ";  

?>

jebster

Doesn't produce any results. 😕

tuf-web_co_uk

<? 
$time = date("Ymd");  

$time = $time - 7; 
time .= "0000";

$sql = "SELECT * from table where time = '".$time."' AND time > '".$time."' ";   

?>

try that

jebster

Nope, still doesn't return any results! 😕

Weedpacket

§6.3.4, first example.

jebster

Works! 😃 Thanks