Working on a statistics plugin I needed a way to group records by the day. Turns out it's remarkably easy.
PLAIN TEXT
SQL:
SELECT COUNT(id), theDate FROM TABLE GROUP BY YEAR(theDate), MONTH(theDate), DAY(theDate);
If you just want to group by year and month take off the DAY() part. This would also be a good query to use WEEK() [...]
As geeky as I am you would think I would have heard about Apple Remote before this week. Maybe it's because I haven't been an Apple geek until a few weeks ago.
For those of y'all in my shoes, Remote is a program that you run on your iPhone that connects to iTunes on your computer [...]
It's come up a few times where I've needed to get a screen shot from my iPhone. Turns out there are two ways to do it, one of which is built into the phone.
Easiest way is to hold down the home button and press the power button. You'll hear the shutter sound and the screen [...]