Storing Multiple Items In One MySQL Field

/ Misc / by Paul Robinson / 4 Comments

A little while ago I posted about storing more than one piece of information in a MySQL table field. This can help with storing arrays of data that do not need to be included in a relationship. Anyway the trick here is to first place the information you want to store in your MySQL table into an array, so let’s […]

Read more

Storing IP Address Data In A MySQL Database

/ Misc / by Paul Robinson / 6 Comments

Today we are going to take a look at one of the most efficient ways to store IP addresses in a MySQL database. You may think that you would store an IP address as a VARCHAR(15) field and you could, but this is not the most efficient way to store IPs. Instead you could use an INT. Please remember though […]

Read more

I'll keep your WordPress site up-to-date and working to its best.

Find out more