Tag Archives: sql

MySQL Difference Between Dates In Days, Hours, Minutes

I was researching how to make a JavaScript countdown timer for a personal webpage, because that’s the only way to go if you want interactivity (client-side scripting at its best), and I thought, ‘how can I do this in MySQL?’ … Continue reading

Posted in MySQL | Tagged , , , | Leave a comment

Working With XML/XSLT, JSON, And PHP

So, this tale, which for your sake I will attempt to make brief, is typical of my experiences in web development. As one of my old bosses used to say (and I’m paraphrasing), “if there’s a hard way to do … Continue reading

Posted in PHP | Tagged , , , , , , , , , , , , , , | Leave a comment

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

Posted in MySQL | Tagged , , , , , | Leave a comment

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

Posted in Computer Stuff, jQuery | Tagged , , , , , | 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

Posted in MySQL | Tagged , , | Leave a comment

Trigger Block Logic Or Why I Learned To Love Outlines

As a child they tried to teach me many things that I resisted learning. How could this possibly be useful was my first question? That, and the fact that their rigid teaching methods didn’t consider learning a concept enough, caused … Continue reading

Posted in Computer Stuff, SQL, writing | Tagged , , , , | Leave a comment