Rui Miguel Feio

How to move a WordPress site to a different Server or URL

8th August 2009 Rui Miguel Feio

Moving a WordPress site from one server to another or to a different Web address (URL) may seem a daunting task and something to stay away from. The truth is that it is quite simple! Last month I was asked to help moving a WordPress (WP) blog from one server […]

How to select the First row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the first row from a MySQL table: SELECT * FROM table LIMIT 1 Explanation: table – table name By limiting the returns to 1 (LIMIT 1) we get the first row from the table. Example: SELECT * FROM tusers LIMIT 1

How to select the Last row from a MySQL table

6th July 2009 Rui Miguel Feio

You can use the following command to get the last row from a MySQL table: SELECT * FROM table ORDER BY field DESC LIMIT 1 Explanation: table – table name field – table field This command orders the table by DESCENDING order and limits the number of rows returned to […]

Select random rows from a MySQL table

6th July 2009 Rui Miguel Feio

If you ever come across the need of randomly select rows from a MySQL table: SELECT * FROM table WHERE field1 = value ORDER BY RAND() LIMIT x Explanation: table – table name field1 – table field value – value you want field1 to be x – number of rows […]

The 12 Principles Of Successful Freelancing

5th July 2009 Rui Miguel Feio

This was taken from the book “The Principles Of Successful Freelancing” authored by Miles Burke (which I highly recommend) and should be used as guide lines to your sucessful freelancing career: Get Organized – Keep your workspace tidy and plan ahead (short- and long-term). Control Stress – Remain calm and […]