In this article, I will show you how to configure a CSV properly and then import the CSV file into MySql. A client of mine recently asked me if I could upload his .CSV file into a MySQL database. He runs a sports site and wanted to have the entire NBA schedule available in MySQL. [...]
Continue reading...12. November 2010
This is just a quick tech note on Windows 7 Screen behavior and the new feature in which the screen maximizes when you drag it partially off the screen.
Continue reading...29. August 2010
This is a technical post on how to convert from MyISAM to InnoDB using phpMyAdmin. Yesterday, I was using phpMyAdmin to set up database tables in MySQL. The solution that I was implementing called for me to use foreign keys to relate the tables to one another. Well, foreign keys require the use of the [...]
Continue reading...29. August 2010
This is a technical post for those who are receiving the message “The Used Table Type Doesn’t Support FULLTEXT Indexes” in phpMyAdmin.” I received this message as I was trying to convert a MySQL table from MyISAM to InnoDB in phpMyAdmin. I was converting this MySQL table from MyISAM to InnoDB so that I could [...]
Continue reading...27. May 2010
When you begin using WordPress, you realize that it can be fairly easy to setup a website quickly. However, when you wish to customize your WordPress, it is then that you can run into many problems. One of the problems that many people run into with WordPress is the order of their categories. In this article, I will tell you how to arrange your WordPress categories using the WordPress “My Category Order” plugin.
Continue reading...13. May 2010
Learn how to show WordPress Category IDs so that you can customize your WordPress Categories and catapult them to the top of the search rankings.
Continue reading...13. May 2010
In this article, we will take a quick look at how to redirect Google search image results to the actual web page that hosts the image. Occasionally, there are those little things that you can do which yield large results. This is one of them--take advantage of it!
Continue reading...22. April 2010
There have been many occasions in which I have had to setup Web Authentication for websites or particular web pages. In this article, I will tell you how I set up web authentication using PHP and MySql and where the real power lies in this technology.
Continue reading...10. September 2009
Often, Google Adsense and other advertising programs do not suit your needs. Thus, you need to create your own Google-like ads. In this article, I'll explain how to create your own custom revolving ads for WordPress or your website using a relatively simple PHP script.
Continue reading...3. September 2009
This article reviews a quick way to do a search and replace in MySQL using phpMyAdmin. This solution can be used to do a quick search and replace of any condition within your MySQL database fields.
Continue reading...
18. November 2010
3 Comments