articles | Page 2 | Richard Cummings

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

Richard CummingsJanuary 7, 2011Quick Solutions, Technologies/Solutions6 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 who puts in an apostrophe. … Read More

PHP: Convert Variable To Date

Richard CummingsNovember 18, 2010Quick Solutions, Technologies/Solutions, Web Consulting2 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, today I will show you … Read More

Import CSV File Into MySQL

Richard CummingsNovember 18, 2010Quick Solutions, Technologies/Solutions, Web Consulting3 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. He presented me with the … Read More

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

Richard CummingsNovember 12, 2010SEO/Site Promotion, Web Consulting7 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.

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

Richard CummingsNovember 12, 2010Quick Solutions, Technologies/Solutions1 Comment

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.

Link Redirecting Vs Link Cloaking

Richard CummingsOctober 6, 2010Making Money Online, Web Consulting2 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.

Convert MyISAM to INNODB using phpMyAdmin

Richard CummingsAugust 29, 2010Quick Solutions, Technologies/Solutions9 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 InnoDB search engine instead of … Read More

The Used Table Type Doesn’t Support FULLTEXT Indexes

Richard CummingsAugust 29, 2010Quick Solutions, Technologies/Solutions2 Comments

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 create foreign keys in MySQL … Read More

Google Mayday Update: Fair and Balanced?

Richard CummingsAugust 20, 2010SEO/Site Promotion, Web Consulting2 Comments

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“?

WordPress: How To Order WordPress Categories

Richard CummingsMay 27, 2010Technologies/Solutions, Web Consulting9 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.