GizmoLA.com - Comments

Eric Tamo: Finding "Next Monday" using MySQL Dates

nospam@example.com (Eric Tamo) — Mon, 27 May 2013 21:53:41 -0700

Thanks for Jade. your code gave me an idea on how to get the following friday of a given day.

SELECT DATE_ADD(CURDATE() , INTERVAL( ( 6 - IF( DAYOFWEEK( CURDATE() ) in(6,7), DAYOFWEEK(CURDATE()),DAYOFWEEK(CURDATE())) ) )
DAY as FRIDAY_OF_DATE

Stas Ustimenko: XDebug for developing, debugging and profiling PHP

nospam@example.com (Stas Ustimenko) — Tue, 29 Jan 2013 05:56:36 -0800

my choice is Codelobster PHP Edition - http://www.codelobster.com
It has very good free PHP debugger

David: XDebug for developing, debugging and profiling PHP

nospam@example.com (David) — Fri, 11 Jan 2013 23:04:46 -0800

This article was originally written for flingbits.com and published in 2010.

Jim: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (Jim) — Thu, 06 Dec 2012 15:10:27 -0800

Thank you for posting this. I spent two days of frustration and desperation trying to get a simple cron working. You saved me from losing my mind! :-)

zz: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (zz) — Sun, 11 Nov 2012 20:03:08 -0800

Thanks for posting this fix!

Haven't used *nix in a while but it's now slowly becomming a bigger part of my life...

(lots of memory work)

fuzzycheck: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (fuzzycheck) — Thu, 09 Aug 2012 06:19:27 -0700

Hi,
the procedure didn't work for me, but I found the reason: the file must not have a BOM, in addition to being in Unix format.

I create my scripts in Notepad++, and it gives the option of saving files in UTF8 format with a BOM, or without a BOM. The BOM adds a few characters at the beginning of the file.

You can check with hexdump:
a file with BOM:
hexdump -C compile_gtk.sh
00000000 ef bb bf 23 21 2f 62 69 6e 2f 73 68 0a 0a 46 49 |...#!/bin/sh..FI|

same file without BOM:
> hexdump -C compile_gtk.sh
00000000 23 21 2f 62 69 6e 2f 73 68 0a 0a 46 49 4c 45 3d |#!/bin/sh..FILE=|

The difference is the first 3 bytes "ef bb bf".

In VI, to check if the file has a BOM, type ":set bomb?". A message "bomb" or "nobomb" should appear.

To remove the BOM, type ":set nobomb", then save the file. Check again with hexdump that the BOM was removed.

Katai: Finding "Next Monday" using MySQL Dates

nospam@example.com (Katai) — Thu, 19 Jul 2012 02:09:16 -0700

Actually, you can change the result of 'dayofweek()' to some degree, with modulo.

You need that a lot if you want a format like '0=monday, etc' instead of sunday.

To make monday == 0, just add '-1, +6, %7'

Example: SELECT ((DAYOFWEEK('2012-07-16') - 1) + 6)% 7

this returns last monday, as 0

SELECT ((DAYOFWEEK('2012-07-22') - 1) + 6) % 7

this returns next sunday as 6

Alvin567: Calculate a person's age in a MySQL query

nospam@example.com (Alvin567) — Mon, 16 Jul 2012 23:36:40 -0700

I have found the answer to date mth year column in mysql

David: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (David) — Tue, 10 Jul 2012 23:51:03 -0700

Awesome! Thanks for this article. Saved me some headache.

Mike: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (Mike) — Sat, 30 Jun 2012 17:03:28 -0700

Great, works perfectly thank-you!

Bazzard: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (Bazzard) — Sun, 24 Jun 2012 18:49:21 -0700

Very helpful. tnx

jaffa: Load the Url symfony helper in a model or form class

nospam@example.com (jaffa) — Thu, 31 May 2012 05:16:34 -0700

Great blog.

Linux n00b: Install Xwindows and Gnome on Centos with Yum

nospam@example.com (Linux n00b) — Tue, 01 May 2012 06:15:08 -0700

Not helping :(. i already installed gnome, but i can't open it? when i do gnome-session it says WARNING: ** Cannot open display. Any help??

Robert: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (Robert) — Wed, 25 Apr 2012 16:12:01 -0700

I had big problems trying to run python script written under Windows on Debian. I've searched many sites and finally I've found your solution. It is working like a charm. Thank you very much.

3l4d2: Linux shell scripting: bad interpreter: No such file or directory

nospam@example.com (3l4d2) — Mon, 26 Mar 2012 00:31:46 -0700

thanks! works like a charm!