CONCAT() and RTRIM() both return NULL if any of their arguments are NULL. So CONCAT(‘xyz’, NULL) returns NULL. RTRIM(NULL) returns NULL. CONCAT(‘xyz’, NULL, ‘123’) returns NULL. coalesce(FIELD, ‘—‘)
Category Archives: Programming
PHP pseudo-cron
Pseudo-cron uses a syntax very much like the Unix cron’s one. For an overview of the syntax used, see a page of the UNIXGEEKS. The syntax pseudo-cron uses is different from the one described on that page in the following points:
Install mcrypt
If using a Debian-based Linux system, you can run the following commands: sudo apt-get install php5-mcrypt sudo /etc/init.d/apache2 restart
PHP Error: Fatal error: Unable to read X bytes in Y.php on line 0
“Fatal error: Unable to read X bytes in Y.php on line 0″ is an error I got once after moving a site to another server. The file was encoded with Zend Optimizer so I could not check what is happening on line 0 that could make any problems. After doing some research I found that …
Continue reading “PHP Error: Fatal error: Unable to read X bytes in Y.php on line 0”
MAC STYLE MENU “Outside the Box” Navigation with jQuery
Just about every website uses the regular navigation concepts we’re all used to. After awhile this can get pretty boring, especially for designers who thrive on creativity. While mimicking the OS X dock and stacks isn’t new, it’s certainly not common.
CSS How do I disable textarea resizing?
textarea { resize: none; }