MySQL Multiple Table Select (Union)

Here’s a quick one.. Say that you have 3 tables in a database –  each with separate results, but each with a timestamp of when the result was added to the table. A good example could be forums. This timestamp goes under the column name “tm” If you want to get the highest (newest) single [...]

PHP SQL Class

After getting tired of typing the same SQL commands into PHP scripts,  I decided I should make a simple class to do all of the hard work, and generally make things quicker. Here is the code so far: <?php class mysql { // Connect to the MySQL host and select the database function connect() { $hostname = “SQL_Address.site.com:port”; $database = “SQL_DB”; $username = “SQL_Username”; [...]

New site (hopefully) soon

There should be a new portfolio site I am designing for someone available in the next week or so.. depending on a few things. Also, my new portfolio site is almost complete. There may be some validation errors etc but these should be fixed in the next week or so. The site uses HTML5 / [...]