Home arrow SQL arrow Page 2 - Lies, Damn Lies, Statistics, and SQL

Lies, Damn Lies, Statistics, and SQL

sqlHeard about the Developer Shed December Giveaway?  Peter has a method useful for all things statistical.  In this article, Peter shows us how you can make use of some quick methods to generate statistics for your sites or projects in as little time as possible.  Using MS Access and a little SQL code, Peter is able to devise an algorithm useful for determining this month's winner.

Author Info:
By: Peter Lavin
Rating: 3 stars3 stars3 stars3 stars3 stars / 23
December 23, 2003
  1. · Lies, Damn Lies, Statistics, and SQL
  2. · Finding the Data
  3. · Capturing the Data
  4. · Into the Database
  5. · The Contest SQL
  6. · Conclusion

print this article

Lies, Damn Lies, Statistics, and SQL - Finding the Data
(Page 2 of 6 )

If you go to the Dev Articles site, and look at the left sidebar, you’ll find all the category descriptions followed by the number of articles in that category. Click on “PHP” to navigate to the most popular subject. You’ll be presented with a list of the most recent submissions. Scroll to the bottom of the page, find and click the link to the full list of articles. This is where we will find detailed information about each submission.

Again the articles are sorted by the most recent submission – not a format that is particularly useful to us at the moment. You could probably eyeball the list and form a fairly accurate opinion of the most popular and most prolific authors, but we want to be objective and precise, so we’re going to import this data into a database. There’s far too much data here to even contemplate manual data entry. Let’s see how we might import it with the least effort.

blog comments powered by Disqus

- Focusing SQL Queries
- Complex SQL Queries
- A Close Look at the SQL Query
- Generating Reports with SQL Date Handling
- Creating SQL Reports Based on Date Criteria
- SQL Date Handling and Data Trends
- Date Handling
- Introduction to SQL
- Lies, Damn Lies, Statistics, and SQL

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials