TimeStamp issues..

Anon

Info about little program I am trying to figure out:

I want to be able to find out how many people went to my page, and also be able to look at how many went every day. I was thinking perhaps a timestamp would be appropriate, but having some visualization problems, of how would I be able to display per day.

For example:

07/12/2000 http://localhost/test1.php visits: 15
07/13/2000 http://localhost/Iwannacar.php visits: 30

Basically like this, but for the life of me, I can't see how you can get this result from an sql query, because timestamps also include hours, minutes and seconds. Any help on this issue would be greatly appreciated...

Anon

Not a problem bud. With the date function you can format the stuff the way you want it, without the time...jsut use:

$date = date("n/d"); and tada, magic is made. That's the format of 7/23/00 or whatever..if i remember correctly

Anon

Hmm, how about on the database side of things?

For example:

select * from where day > '09/07/2000' and day < '12/07/2000' group by day, site

I would like to get output like, this:

09/07/2000 http://www.slashdot.org 1213111
09/08/2000 http://www.linux.org 123111

But since the timestamp also includes hours, minutes, and seconds, you get instead something like this

09/07/2000 00:01:00 http://slashdot.org 1
09/07/2000 01:01:00 http://slashdot.org 1
09/07/2000 00:23:00 http://disney.org 1
09/07/2000 12:11:00 http://disney.org 1

as you can see, although this happens on the same day, they get separate clicks when in fact they should have had been assigned similar. I was thinking about forgoing all this and makeing time a string, where it looked something like this 2000.09/07
But that has problems

Anon

This is slightly altered from:
http://www.phpbuilder.com/forum/read.php3?num=2&id=103931&thread=103907

mysql_connect("$DBHost","$DBUser","$DBPass") or die ("The database server is temporarily down for maintenance...");
$result=mysql("$DBName","SELECT url, entry_time FROM your_table");
while ($Nrow = mysql_fetch_row($result)) {
$Nurl=$Nrow[0];
$Ntim=$Nrow[1];
$pieces=explode(":",$Ntim);
if ( ereg( "([0-9]{4})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})([0-9]{1,2})", $Ntim, $regs ) )
if ($Ntim != "") {
echo "$regs[2]/$regs[3]/$regs[1] $Nurl";
}
}