Works like a charm in mysql:
Of course, decrement is also possible
Increment int value in sql update statement
September 20th, 2011 | No Comments »configure local timezone on debian
December 1st, 2010 | No Comments »run
dpkg-reconfigure tzdata
on the command line. You will be promt for your local details.
Simple:
server:~# dpkg-reconfigure tzdata
Current default timezone: ‘Europe/Berlin’
Local time is now: Wed Dec 1 10:43:56 CET 2010.
Universal Time is now: Wed Dec 1 09:43:56 UTC 2010.
Great online photo and image editor
March 17th, 2010 | No Comments »Recently I stumble over a great online service for editing photos and images. It is www.pixlr.com. I was very surprised by the great feature of this free online tool for modifying pictures. And the best of it – and also to my surprise – it works fast.
If you already know Photoshop you will find it read more …
Wordpress get_posts without the current post
March 2nd, 2010 | No Comments »Displaying links to other articles of the same category is pretty easy in Wordpress. get_posts function accept a category parameter. So you can use
to get the the latest five post of the current category.
If the current posts one of the latest five, you can sort it out in this way:
Update: Read update below!
Note: With this read more …
Errors and warnings from Broadcast MU
February 16th, 2010 | No Comments »I just downloaded Broadcast MU Version 1.1.1. This great plugin allows you to have the same post on multiple blogs in your Wordpress MU environment.
If you install it, do not forget to deactivate ‘post revisions’. Your wp-config.php needs
define(‘WP_POST_REVISIONS’, false);.
However, in edit mode and while submitting the post there are some errors and warnings like
Warning: Invalid read more …