Tag Archive | "articles"

Apostrophe, Input Form, PHP, MySQL: The Easy Solution!

Friday, January 7, 2011

4 Comments

In this article, I will tell you how to deal with the apostrophe not working in form data that writes to MySql using PHP. I do a lot of work involving input forms on PHP pages that write the input data to MySQL. Every time I do this, I have to account for the user [...]

Continue reading...

PHP: Convert Variable To Date

Thursday, November 18, 2010

2 Comments

In this article, I will review how to convert a variable that represents a date to an actual MySQL date column using PHP. Dealing with dates and times in MySQL and PHP is at once fascinating and frustrating. Everybody seems to store their date information with slight variances. Thus, everyone’s solution is slightly different. So, [...]

Continue reading...

Import CSV File Into MySQL

Thursday, November 18, 2010

3 Comments

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...

SEO, Squidoo, and HubPages: Are Community Pages Worth Your SEO Time?

Friday, November 12, 2010

7 Comments

Many people use Squidoo and HubPages in their SEO efforts. In this article, I will present many articles discussing Squidoo and HubPages, their differences, and whether they are worth your SEO time.

Continue reading...

Windows 7 Screen Maximizes When Dragged Partially Off Screen | Get Rid of It!

Friday, November 12, 2010

0 Comments

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...

Link Redirecting Vs Link Cloaking

Wednesday, October 6, 2010

2 Comments

If you promote affiliate programs, it is important to understand the difference between link redirects and link cloaking. Some affiliate programs permit both forms of link usage, some permit just one, and others may prohibit both. In this article, I will tell you why this is important, how to find out what is an acceptable practice, and what is exactly the difference between redirecting a link and cloaking a link.

Continue reading...

Convert MyISAM to INNODB using phpMyAdmin

Sunday, August 29, 2010

8 Comments

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...

The Used Table Type Doesn’t Support FULLTEXT Indexes

Sunday, August 29, 2010

1 Comment

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...

Google Mayday Update: Fair and Balanced?

Friday, August 20, 2010

2 Comments

Google Mayday Update:  Fair and Balanced?

Near the end of May, Google released an update to their search algorithm-dubbed “Mayday” by most-that affects natural search engine rankings, especially for what are known as “long-tail keywords“. In looking at this Mayday update, we will ask the question: Are these Google updates “fair and balanced“?

Continue reading...

WordPress: How To Order WordPress Categories

Thursday, May 27, 2010

9 Comments

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...