Select todays entries

[dhimok]

Hi!

 

How do I select entries that have been submitted today in sql. thanks

 

[darkfreaks]

whats the code?

[micah1701]

'um, what format is the date stamp in mysql?

 

if its standard:  YYY-MM-DD

 

then:

 

$today = date("Y-m-d");

$sql = "SELECT * FROM table WHERE datestamp = $today";

[dhimok]

date is a timestamp 10 digits

[darkfreaks]

actually that would work. it would display the year month and day in number format

[photowborama]

'um, what format is the date stamp in mysql?

 

if its standard:  YYY-MM-DD

 

then:

 

$today = date("Y-m-d");

$sql = "SELECT * FROM table WHERE datestamp = $today";

Does mysql date stamp every entry?  I thought you had to put a date stamp field in the table before you sort off of it...

[dhimok]

the date field is int(10) unsigned not null

[micah1701]

date is a timestamp 10 digits

 

I'm assuming this 10-digit date field is being populated with each new entry right?

 

then similar to my first suggestion:

$today = strtotime(date("Y-m-d")); //returns 10 digit time stamp of midnight this morning

$sql = "SELECT * FROM table WHERE date >= $today";

 

 

[dhimok]

I was wondering

 

How to count entries or hits made each hour of the day?

[darkfreaks]

counts each row

 

<?php

$row = mysql_fetch_array($res);
echo count($row); ?>

[dhimok]

how do we count in sql

[darkfreaks]

Example:

<?php 
$res = mysql_query("select * from blah") // a query that returns an empty set 
$row = mysql_fetch_array($res); // get's 0 since there's no return 
echo count($row); // echos 1 - since $row is not an array 
echo $row[0]; // echos "", but casts $row as an array? 
echo count($row); // echos 0 now 
?> 

[micah1701]

I was wondering

 

How to count entries or hits made each hour of the day?

 

why didn't you ask that then?

 

to count the hits for today, use my previous code then just count the rows returned:

 

$today = strtotime(date("Y-m-d"));

$sql = mysql_query("SELECT * FROM table WHERE date >= $today");

echo mysql_num_rows($sql);

 

to get results by hour, modify the $today string in from my example.

look at http://www.php.net/date and http://www.php.net/strtotime

[dhimok]

Ok all I want to do is to loop all hrs of the day like

 

00 01 02 03 04 05 06 ... 12 13 ...  20 21 22 23

 

and then get the nr of hits for each one

 

 

[micah1701]

didn't test this but how 'bout:

 

<?php

$start= strtotime(date("Y-m-d"));
$sql = mysql_query("SELECT date FROM table WHERE date >= $start");

for($i=0;$i<mysql_num_rows($sql); $i++){
$date = mysql_result($sql,$i,0);
$nextHour = $start + (60*60); 

  if($date >= $start && $date < $nextHour){
   $hour[$i] = $hour[$i] + 1;
  }

$start= $nextHour;
}

print_r($hour); //array of hours with values equal to number of entries each hour

?>