-
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)
Database Archive
-
Import CSV file to MySQL Database using PHP
Posted on July 28, 2009 | No Comments<!--p /** ~~~~~~~ CSV IMPORT TO DATABASE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ * * This script reads in a comma delimited text file (.csv) and creates * a table in the database from... -
Re-numbering an auto-increment column
Posted on November 3, 2008 | No CommentsAn auto-incremented column can become a little cluttered if records are deleted from the table, and you may wish to delete the slack of the sequence in your id column... -
Time Stamp differences in MySQL and PHP
Posted on September 2, 2008 | No CommentsMySQL and PHP handle time and data data in different ways, and it's important to be aware of the difference. Both these environments have a TIMESTAMP construct, but they're not... -
Pulling a single value from the database
Posted on June 18, 2008 | No CommentsSometimes you just want to pull a single value from the database without a whole lot of work. Here's how to do it in a single line; // mysql_result() function... -
Database Primer
Posted on November 27, 2007 | No CommentsA database is a structured collection of information. This is not a database; Adam Thomson, 555-6335 Anita McColl, 108 Verdun Ave., 555-5249 But this is; Adam Thomson, , 555-6335 Anita...