-
Recent Posts
Recent Comments
- robert on Terminator Zombies
- robert on Stories I Tell To Entertain The Weak Minded
- nouveau maillot barca on Parsing XML With PHP SimpleXML
- PutThatThornBack on iCrap, Or Why I Hate Apple Products
- bear on A Public Service Announcement from F.O.O.D.
Archives
- May 2025
- March 2025
- December 2024
- April 2024
- December 2023
- October 2020
- September 2020
- January 2020
- March 2019
- November 2018
- August 2018
- July 2017
- June 2017
- December 2016
- May 2016
- April 2016
- July 2015
- June 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- May 2014
- April 2014
- September 2013
- December 2012
- November 2012
- August 2012
- June 2012
- May 2012
- March 2012
- February 2012
- November 2011
- October 2011
- September 2011
- July 2011
- June 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
Categories
- Airlines
- Art
- Complaints
- Computer Stuff
- crafts
- crochet
- Electronics
- Fun With Photoshop
- Government
- Gringo America
- jQuery
- Mac
- Movie Reviews
- My Opinion
- My WordPress Experiences
- MySQL
- Off Thoughts (Off as in Not Quite Right)
- PHP
- Poetry
- Remember When
- Reviews
- SQL
- Superheroes
- taxes
- Travel Agencies
- Useful Thoughts (as Opposed to Off Thoughts)
- writing
Meta
Author Archives: robert
Arrival At Pluto
New Horizons is scheduled to arrive at the PLANET Pluto (don’t give me any of that dwarf or minor crap) on: select DATE_ADD(date(‘2015-06-02’), INTERVAL 42 DAY) as ‘Arrival at Pluto’; Kind of sad that I thought it would be easier … Continue reading
Plumber Truck Graphic
Today a plumber’s truck stopped at a neighbor’s house. The graphic on the back door sent my mind into overtime (as per usual). Here is the original: Here is one of the ideas that popped into my head: I had … Continue reading
The Divergent Series: Insurgent Review
I finally got around to seeing the movie today (probably one of the last to see it at the theater). To be honest, it surprised me that it was in the theaters so long. I guess it struck a cord … Continue reading
Having Conversations With Javascript
Have you ever wanted wanted to animate inanimate objects? I think we all have. Well, that’s a lot of work. A cheat that you can employ, however, is relatively easy with javascript and or jquery. No, I’m not talking about … Continue reading
Japanese Transistor Radio
Remember when portable radios (A.M. radio) were the size of a large boom box and used half a dozen "D" batteries and or a lantern battery (a large, heavy, rectangular battery)? Okay, that might be a slight exaggeration. Then, one … Continue reading
Graphing With Flot
I was working on one of my personal projects, graphing data with PHP, when I ran into a wall. Sure, with PHP, you can get all your data (in the words of some famous poet: database, oh database, how do … Continue reading
John Wick – The Scottish Country Western Action Movie
I saw a trailer for John Wick the other night, and my curiosity was peaked sufficiently that I plan on watching it. I think, though, the editors/makers of the commercial/trailer for the movie, need a vacation, or need to be … Continue reading
Install A Linux Web Server On Your Windows 7 PC With Vagrant
First, I’d like to reference an excellent video tutorial that I used for my initial foray into the Vagrant world. Click here to see that tutorial. Disclaimer: This blog entry does not necessarily follow safe computer/networking procedures. Use this only … Continue reading
Posted in Computer Stuff, MySQL, PHP
Tagged installation, mysql, PC, php, script, vagrant, windows 7
Leave a comment
MySQL Query Using Derived Temp Table And Left Join Against Self
An example (for a personal project) where I’m using a derived temp table (designated ‘x’) and a table joined against itself, used to find the max timestamp. Thanks, Martin! select tt.*, fkid, max(fldTimeStamp) as `maxTimeStamp`, (count(*)-1) as `calcCount` from tbl_todo … Continue reading
Terminator Zombies
So, my brother is watching the second Terminator movie (one of my favorites) in the living room. I can hear it well enough, but I’m trying to concentrate on something else. The scene where the doctor says good morning to … Continue reading
