MySQL Tables Can Crash!
I didn’t know until it happened to me recently, but MySQL tables can crash. When one of my tables crashed the first I knew about it was when I tried to browse it using phpMyAdmin and received an error message.
I didn’t know until it happened to me recently, but MySQL tables can crash. When one of my tables crashed the first I knew about it was when I tried to browse it using phpMyAdmin and received an error message.
Ever wanted to test a regex (regular expression) quickly and easily? Now you can!
As of Word 2007, Microsoft Office introduced a new file format (and extension) for Word, Excel, and PowerPoint documents. Prior to this, Word documents had the .doc extension, but new documents end in .docx. This can be a problem if you have a version of Microsoft Word prior to 2007, as there is no support for the new .docx format, and if someone send you a file in this format, you can’t open it!
Ever had trouble dropping onto a new line in Excel? I had tried all sorts of ways to insert a new line into an Excel spreadsheet without success.
The Apache web server’s mod_rewrite module is a powerful tool for rewriting URLs. It can catch you off guard in certain situations. For example, if you’re matching a URL to rewrite or redirect to another, you may find that any query string is unexpectedly passed along, too.
Continue reading ‘Stop Apache mod_rewrite Appending Query String To Redirects’ »
Sending email using PHP on a Windows IIS server is not as simple as it is when using a Linux server. On a typical setup the mail() function probably won’t work without some tweaking.
Continue reading ‘Sending Email with PHP mail() on a Windows Server’ »
Usually our SQL queries use JOIN
s in SELECT
queries. But what about if you want to DELETE
using a JOIN
? It’s not as straightforward.
Ever need to order an SQL query by the surname/last name of a user, but their full name is all one single field? Here’s how to use some of MySQL’s string function to do just that!
Continue reading ‘SQL Query To Order By Surname When Name Is All One Field’ »
WordPress is a great piece of blogging software. With very little experience you can have your own blog set up within minutes. However, WordPress does have its faults. One common complaint is that WordPress is slow, and gets slower as more posts are added. Fear not, because help is at hand! One simple change to your .htaccess file can optimise WordPress and speed your blog up dramatically.
If you have some ASP pages that you want redirecting to new URLs with the correct “301 Moved Permanently” status, this simple solution is easy to implement.