Sponsored Links

Stop the Skype plugin from breaking your design

Skype logo

It took me a bit of searching to find this line of code to stop the Skype browser plug-in from automatically styling all the telephone numbers in your [...]

Superfish Menu

jQuery logo

After a long struggle to find a simple menu script for a web application,  I came across Superfish, a beefed-up version of the Suckerfish menu, that takes a CSS menu and uses jQuery to provide some enhancements.

I have implemented this menu and so far have had no issues with it in Firefox, Internet Explorer 6 [...]

MySQL sub-query

I have blogged before about simplicity in code – how the simplest solutions are usually the best, and I normally put it down to [...]

MySQL simplicity

MySQL logo

I love the fact that the best solutions are almost always the simplest!

I spend a lot of time sanitising data. I use Excel a lot of the time to perform most of the work – but I am slowly starting to use more and more SQL in my MySQL databases to do the work.

 

Today after [...]

Timezones and PHP

Calendar image

Following on from an earlier post where I mentioned the large amounts of date work I have to deal with, here is the way I am dealing with time-zones in my PHP [...]

WordPress Meta tags & SEO optimisation

WordPress logo

I assumed that part of the reason blogs rated well with search engines was because things like meta tags were taken care of for you. I was hugely surprised when I viewed the source of my blog pages on my hiking blog, [...]

Submit a form with a radio button using Javascript

My boss (god bless his little cotton socks) wanted me to implement some code that submitted a form when the user changed the selection in a set of radio buttons.

This seemed fairly simple: surely I could just do something like:

<form method=”GET” action=”mypage.php”>
<input type=”radio” name=”dateselect” id=”today” onClick=”submit();” value=”today” />
<input type=”submit” name=”submit” value=”Submit Selection” />
</form>

Apparently not. Firebug [...]

PHP dynamic year selector

PHP logo

After 2009 rolled in and all our sites failed to follow suite because  “someone” hard-coded the years — but only up to 2008 — I quickly had to write something a bit more — well, smart.

I needed an HTML drop-down box with a set of years starting from a fixed year, but extending to the current year so [...]

MySQL TRIGGER

MySQL logo

I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could find were all to complex and I could not get any of them to work. Here is a quick little example that you should find really easy to [...]

Interbase query pain

Here I was thinking that modern RDMS’s supported a standard set of SQL commands…

So imagine my surprise when I issued SELECT * FROM table_1 JOIN table_2 ON table_1.id = table_2.id and only got fields from table_1 in my result set.

Because clearly Interbase expects the verbose SELECT *.table_1, *.table_2 FROM table_1 JOIN table_2 ON table_1.id = [...]