Jump to content

Query Help


matchoo

Recommended Posts

Hi there.

 

I need some SQL advice.

 

I have a database of website usage data.

 

There is a table named 'pages' and it has the following columns:

 

page_id

date_logged

comment_count

view_count

 

I have been asked to figure out if comments are a predictor of page popularity (view counts). 

 

I would like to do a query that returns week to week variance numbers for comments and views and chart it.  Then sort by highest current view counts.

 

Does that sound like a good way of getting this information?  Anyone feel like throwing a SQL query up to show an example of what that might look like?

 

Thanks,

 

Matchoo

Link to comment
https://forums.phpfreaks.com/topic/54455-query-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.