Using WordPress for websites that aren’t just weblogs means the need to modify WordPress more & more. Recently I was asked to change the order of the posts displayed when using the post link functions.

A tricky subject I came across recently was how to use Triggers in a MySQL database. I always stayed away from them as I thought they were difficult to work with, but it turns out they are much easier than I expected.

Following on from the last tutorial, we are going to take a look at how to assemble some slightly more complex queries to filter the results from our many to many relationships.

A fairly difficult subject to approach in MySQL is Many to Many relationships. The queries can be complicated and the data sets huge, but as it seems to be covered by tutorials very little I thought I’d have a shot a writing a tutorial about it.

I have had a few questions recently asking what sub queries are and how they are used. While there are a number of articles out there on the subject they don’t explain it in a detailed manner as I would like. So here is my take on them.

I originally wrote a post about 2 year ago explaining how to store multiple values in a single MySQL row. Now I have more experience with PHP/MySQL I have decided to revisit this topic to clear up any confusion about the method that should be used.

Continuing on from the last post which covered the basics of connecting to a database using MySQLi, we are going to look at inserting, updating & deleting data. Finally we are going to look at some of the miscellaneous features of MySQLi.

A limitation with searches using MySQL is that when using LIKE to find the words queried it will only find them if they are together in the same order they were written. Here is how to change that so the words are found in any order.

Ok, so yesterday I did a tutorial about making a animation similar to that which WordPress uses when you delete posts etc. You know the fade to red & slide up thing… Yep? Good.

So a few people have contacted me asking me how to create a table that sorts without contacting the MySQL server again. Well it’s simple, I use a extremely powerful jQuery plugin called TableSorter 2.0 made for jQuery by Christian Bach. The hard part is integrating it into your data which is probably generated by [...]

A little while ago I posted about storing more than one piece of information in a MySQL table field. This can come in handy for quite a few reasons, none of which I can think of right now, but really it does. Anyway here is a trick for doing this in a much better way, [...]

So after a little rest from coding I’m back with this little conundrum that hit me about 4 or 5 year ago, but seems to have come back to haunt a lot of people recently. The problem is storing multiple values in one field when using a MySQL database. The project I worked on all [...]