Author Archives: Jesper

MySQL fulltext searches

January 13, 2009 Jesper MySQL

MySQL have a very nifty search function built in, which in many ways are more sophisticated than the WHERE LIKE (‘%’). Using full text search with MATCH (…) AGAINST (…) AS relevancy it is also possible to get results ranked … Continue reading →

Popularity: 5% [?]

Comments Off

Including chapter number in figure captions

January 13, 2009 Jesper Word

Sometimes you need to include chapter number in captions; e.g Figure 2.1 To do this automatically you need to setup the caption format. In Word 2003 this was very easy. In Word 2007 it is also very easy, but a … Continue reading →

Popularity: 5% [?]

Comments Off

PHPMailer : Language string failed to load: instantiate

January 8, 2009 Jesper PHP, web development

This problem were driving me nuts for a couple of hours so I decided to post it here, to the benefit of others. Using the PHPMailer class to send mail to members from one of our sites I were writing … Continue reading →

Popularity: 9% [?]

3 comments

Selecting / joining two tables in MySQL – explained

November 28, 2008 Jesper MySQL

Trying to create MySQL queries can be a daunting task for the beginner and before understanding the logic it can be really confusing. A common task is to select related data from two tables to generate for example a list … Continue reading →

Popularity: 5% [?]

Comments Off

Generate a heatmap of your site

September 20, 2008 Jesper web development

I stumbled over a couple of very interesting sites today. Have you ever heard of Jacob Nielsen and heatmaps? Sure you have, how would you ever find this post unless you searched for “heatmap”,  right? (I also wrote about heatmaps … Continue reading →

Popularity: 5% [?]

1 comment