Quick Tip: Working with MySQL and SUM
Updated: 2010-08-31 23:17:23
In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and [...]
Rap enthusiasm site, Rap Genius has gone through the impressive tasks of combing rap and Google Maps. Rap Genius' Rap Map is a Google Map-based visual almanac of all things rap. You can scan an area and view rap landmarks and places mentioned or referenced in some famous rap lyrics.
The 'Big Data' service Infochimps now offers IP geolocation from Digital Element. Infochimps is best known for making huge datasets available as bulk downloads and through RESTful APIs. Digital Element has traditionally offered enterprise level services to large companies like AOL, CNN, and Ask.Com. Both companies hope that the Infochimps RESTful API interface and aggressive entry pricing will entice smaller companies to use the service.
In this tutorial, we’ll learn how to create a slick email signup form. This form will harness the full power of AJAX, meaning that we will submit data to the server, validate it, and receive a response – all without a single page refresh! Along the way, you should pick up some useful tips related [...]
: Register Login Hot APIs Twitter YouTube Facebook Google Maps Flickr LinkedIn More Latest news Putting Rap on the Map . . Literally Home PW Home Tour API News Blog Home Recent Popular News All Time Popular Featured Articles API Directory API Dashboard API Directory Newest APIs Most Popular APIs APIs By Category API Scorecard Add an API Mashups Mashup Dashboard Mashup Directory Newest Mashups Most Popular Mashups Mashup Matrix Mashup Tag Cloud Random Mashup Add a Mashup Community Dev Dashboard Community Directory Forum Member Map How-to Code Dashboard How-to Guide Reference Contests FAQ : Subscribe RSS Email Twitter Facebook Blog Home Recent Popular All Time Popular Featured Articles Best Mashups Google APIs : A to Z Guest Author August 30th , 2010 Comments 2 This guest post comes from
In this episode of “ASP.NET from Scratch,” we’ll ditch WebForms in favor of ASP.NET MVC. You’ll get a taste of ASP.NET MVC and recreate a EmailForm application using the MVC framework! The Complete Series Lesson 1: Getting Started Lesson 2: Improving an Email Form Lesson 3: Class Inheritance Lesson 4: SQL Server Lesson 5: Master [...]
Years ago, I learned a deceptively simple “assert” function from John Resig, for testing your JavaScript. Amazingly, at barely five or six lines, this code provides a great level of power and control over your code, when testing. I’ll show you how to use it in today’s video quick tip. Screencast Premium Members: Download this [...]
If you’ve been hanging around Nettuts+ for long, you probably know that it’s only one small piece of the huge Envato ecosystem. If you’re interested in becoming a more efficient developer, you’ll want to check out these incredible WordPress, CSS, JavaScript, .NET, and PHP components — all ready to drop into your latest project. WordPress [...]