Moving MySQL databases from one server to another is usually a pretty painless and relatively easy process when the phpMyAdmin tool is available on the hosting servers. An unforeseen hiccup recently presented itself to me when trying to move a WordPress MySQL database from one account to another on the same ISP. It was a situation I had never run into before as usually a move is from one ISP to another. The solution turned out to be rather simple but not necessarily obvious, so I thought I’d share it here! Read the Full Post
PHP: Random Data Retrieval
Sometimes we may want to present our data in an unordered fashion, avoiding alphabetical or date based sorting. For example, creating a “Featured” list of articles that changes upon each page load by choosing a handful at random from our database. Another instance may be wanting to change up an image at random for each page or page load. When dealing with the data in our database with the PHP (Hypertext Preprocessor) programming language, we have several options… Read the Full Post »