Tag Archives: mysql

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

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 , , , , , , | 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

Syncing MySQL Database Between A Mac And PC

I’ve been a long time Mac hater. Recently, though, I broke down and bought a Mac laptop. Being a geek on many levels, I immediately had to set it up as a development server environment. I won’t go into the … Continue reading

Posted in Computer Stuff, Mac, MySQL | Tagged , , , | Leave a comment

PHP Calculate Easter

My browser homepage is set to a localhost php calendar that is connected to a database (to display birthdays, events, reminders, data of all sorts). One of the dates I originally found difficult to calculate was Easter. One of the … Continue reading

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

phpMyAdmin on Windows 7

So, it’s been a while since I upgraded to Windows 7, and I thought everything was tweaked and functioning properly.  Turns out I was wrong.  I tried to login to phpMyAdmin, my favorite means of accessing a database (MySQL), on … Continue reading

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