Jump to content


Photo

datetime


  • Please log in to reply
2 replies to this topic

#1 ajasax

ajasax
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 12 June 2003 - 07:06 PM

I am wondering if there is a way to find information for a specific day. For example, find out the number of hits for a website on the current day.

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 12 June 2003 - 07:21 PM

Two ways of doing this

1. Use a table and update details like number + date (timestamp)
query based on date

select count(*) from counter where date=<ur date>

2. Use a file and create separate file s for each date automatically
and store the hits done

Both has there own advantage + disadvantage

So u have to decide whcih one u are going to go for
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 ajasax

ajasax
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 16 June 2003 - 10:42 PM

I didn\'t think about that. I think I\'ll just store a copy of the date in a separate column. Thanks for the help!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users