weblogs in php/mysql

[Archbob]

Okay, I know how to make a counter and log stuff like OS and stuff like that but I don't know how to make it display by date. The tutorials I've looked through don't help me much.

How do I make it display unique hits on each day?

[zingbats]

right. two things:

1.) Are the logs stored in MySQL or flatfile?
2.)If it is MySQL can you give me the table structure?

You need to create a timestamp field. Then the counter can store the time in to the database.

[Archbob]

Yes, logs are stored in a mysql table? I'm still not sure how to get it to display the number of hits and uniques on each specific day like webalizer does.

[BuzzLY]

As zingbats mentioned, make sure you are storing the time/date of the log in the MySQL table. When you are looking to display logs for a certain date, just do a select query and pull out all logs that match the date you are looking for.

[Archbob]

Okay, that I can do, how do you get them to display in a nice format like webalizer where it displays each month and the the specific days of that month in order on the same page. I can't think of any while loops that would do that.

[BuzzLY]

I have done something similar in the past... what you need to do is order them by date, then loop through each one. Store the date of the first row in a variable called compareDate, then compare the date of the next row to compareDate. If they are different, create a new header with the new date, write the row, put the new date in compareDate, and continue. If they are the same, then just write the row, and continue.

I did a similar thing, but it was a yearly calendar. I used the months as headers -- but it's the same concept.

Hope I was clear enough on how that works.

Good Luck!

[Archbob]

Err, I don't get it, but I'll give it a try.

[BuzzLY]

Here's basically how your loop goes:

Set compareDate = "";
Loop until I'm out of rows {
   Get date column
   If date != compareDate {
      create new header with date
      set compareDate = date
   }
   print out row
}

That should create data that looks like:

1/1/2003
Here's some data
Some more data
1/2/2003
Yet more data, on a different date
1/3/2003
Etc
Etc
1/4/2003
Etc.

Make sense now?

It's up to you to write the code, and format the results. Good Luck!