Tag Archives: MySQL

About working with MySQL databases and the Structured Query Language (SQL).

New website design trends

Update your website with latest trends.

This year has seen many new trends in website design, the updates in CSS3, JavaScript and Jquery along with some innovative designers and coders have seen sites get more engaging for the user. The sites that make use of social media to encourage their users to spread the word about their fantastic new websites will no doubt have benefited from increased awareness and sales as a result. Continue reading

Choosing between PHP and MySQL for quick jobs

I recently imported a database which included a selection of French postcodes. Because of a bug with the original export (received in a spreadhseet) some of the postcodes were missing the leading zeros, and some of them actually had more leading zero’s than were required.

Unfortunately the problem wasn’t raised until the data was imported, and a fresh import was going to take me hours. Fortunately all French postcodes are 5 characters long so it was possible to fix this problem programmatically. Continue reading