MySQL
How to Create a Simple RSS Feed using PHP and MySQL
Generating a RSS feed with PHP is actually very easy. I have had to do it a few different times and every time I do it I have to look up the syntax of the XML document. To save myself time in the future I thought I would document the process here for myself and [...]
Multiple Column Text Search of MySQL Database Using PHP
I have done this a few times but I can never quite remember how it works. Thanks to some assistance from Sheldon I was able to put together this simple tutorial on how to create a PHP search that will automatically search multiple MySQL columns, score the results, and return the results ordered by relevance. [...]
How to Properly Store Currency/Money in MySQL
I have looked this up a number of times because I can never quite remember the exact procedure. I have decided to document this, primarily for myself, but I hope others find it useful as well. They method I have found the most useful for storing money in a MySQL database it using a float [...]
Using MySQL in and between Clauses
In and between are two functions MySQL offers that aren’t something I use on a daily basis but they are incredibly useful from time to time for specific operations. The in() function can be IN() or NOT IN() and the same is applicable for BETWEEN or NOT BETWEEN. Here some example queries of this functionality [...]