Notes on a web journey

posted on: 29 September 2008

MySQL and Regular Expressions

filed under: @ 18:37:02

Tips on using NOW() in MySQL and negative matching with Regular Expressions:


posted on: 21 July 2008

IP to Country

filed under: @ 09:41:02

Creating a database to map an IP address to a country:

How To Make An IP-To-Country Tool With PHP and MySQL


posted on: 10 February 2008

MySQL backup, storing IP and text limit

filed under: @ 10:38:21

Via :


posted on: 15 March 2007

MySQL insert and update

filed under: @ 09:16:41

On Array Studio Workshop:

MySQL insert a new row or update old one


posted on: 15 August 2006

MySQL sorting and PHP sessions

filed under: @ 19:04:23

Some MySQL sorting tips:
sort MySQL results ignoring definite and indefinite articles (the, a, an)
which points to this post
originally meant to answer this thread

And an interesting article on PHP sessions:
the truth about sessions


posted on: 20 February 2006

MySQL Fulltext indexing

filed under: @ 10:29:43

MySQL Fulltext indexing: Dissecting MySQL Fulltext Indexing and
Implementation and Application of Term Weights.

Since the posts search on this site works using MySQL Fulltext indexing I found myself trying to delve a bit deeper into it. I cannot say that everything is as clear as it could/should be, for me anyway..


CSS,Javascript and Php studies

Anti spam email
A solution to writing an anti spam email contact link
filed under: Javascript
Background image
A background image randomizer that I used in the second version of this site.
filed under: Javascript/CSS
Javascript menu
A menu that uses Javascript and session cookies.
filed under: Javascript/CSS
Experimenting with CSS and Javascript.A simple but, in my opinion, nice navigation “system”. The MiniSite is a one page site.
filed under: Javascript/CSS
Photo display
Protect copyrighted photos: a simple but effective solution.
filed under: Javascript/CSS
Photo gallery
A photo gallery made for a friend
filed under: Javascript
PHP menu
A PHP menu that can be updated without having to re-publish all the pages is on.
filed under: PHP
Pop-up menu
A very simple pop up menu powered by Javascript. It works also if Javascript is disabled.
filed under: Javascript/CSS
RSS feed
How to write and use an RSS feed
filed under: rss-xml
Tag replacer
The Tag replacer explained and a link to it.
filed under: PHP
Tags search
A search form build and powered using Javascript and the DOM
filed under: Javascript