-
Recent Posts
Blogroll
Categories
- Application Tips (2)
- CSS (6)
- Database (10)
- DHTML (2)
- DOS & DOS Scripting (2)
- Graphics (3)
- iPhone (1)
- JavaScript (3)
- Joomla! (11)
- Linux (2)
- MySQL (25)
- Networking (2)
- Operating Systems (5)
- PHP (24)
- Resources (2)
- Snippet (1)
- Uncategorized (38)
- Vista (2)
- Web Development (18)
- WordPress (12)
Tutorius Archives
- January 2012 (1)
- December 2011 (1)
- November 2011 (2)
- October 2011 (4)
- September 2011 (2)
- March 2011 (3)
- December 2010 (1)
- November 2010 (2)
- September 2010 (2)
- August 2010 (5)
- June 2010 (5)
- May 2010 (8)
- April 2010 (6)
- March 2010 (5)
- January 2010 (3)
- December 2009 (2)
- November 2009 (11)
- October 2009 (12)
- September 2009 (3)
- August 2009 (8)
- July 2009 (9)
- June 2009 (4)
- May 2009 (1)
- April 2009 (1)
- February 2009 (3)
- January 2009 (3)
- December 2008 (1)
- November 2008 (3)
- October 2008 (3)
- September 2008 (5)
- August 2008 (7)
- June 2008 (3)
- March 2008 (3)
- February 2008 (1)
- January 2008 (1)
- November 2007 (3)
Latest Headlines
-
Make your .php extension optional
Posted on October 17, 2011 | No CommentsPlace the following code in your .htaccess file to make the .php extension on your pages optional. RewriteEngine on # ----- make .php extension optional ----- RewriteCond %{REQUEST_FILENAME} !-f RewriteCond... -
Foreign Keys and Referential Integrity in MySQL
Posted on October 14, 2011 | No CommentsThis TechRepublic article is a good fast introduction to the topic of Referential Integrity and the use of Foreign Keys in MySQL. -
Test for Database Table in PHP
Posted on October 5, 2011 | No CommentsSometimes it's handy to be able to detect whether a given table exists, such as when you want to create a table if it isn't present. The following example will... -
Trim leading whitespace from a field in MySQL
Posted on September 25, 2011 | No CommentsAs always, backup the database or at least the affected table before running a command that will change every record in a table as this does. The following line will... -
Using Variables in MySQL
Posted on September 24, 2011 | No CommentsFinding the correct syntax for using variables in MySQL can be surprisingly difficult. Once you know it, it's easy. Here's a start: SET @username := 'jonesr'; SELECT id,fname,lname FROM staff...