When working with databases, you can use the phpMyAdmin tool to create database, tables, and add content. Along with normal data addition, you may also need to reorganize the way your data is stored. This may involved removing data, or even deleting tables from you databases. This tutorial will guide you on the process of Read More >
Scott Mitchell
Rearranging products and categories in osCommerce
After creating categories and products in your osCommerce, you will want to have them organized. You do not have to worry about the order or where they were originally created as you have the ability to transfer them around from within the admin area. Follow the instructions below to learn how to move categories and Read More >
Deleting categories and products in osCommerce
As you work with your added categories and products, you may eventually have the need to remove obsolete or discontinued items as opposed to rearranging them. Follow the instructions below as we discuss how to remove them from within the osCommerce admin interface. How to remove categories and products in osCommerce Log into your osCommerce Read More >
Modifying the sort order of categories and products in osCommerce
When you are working with your products and their categories in your store, you may come across a time when you need to reorganize the way they are listed. This is done by changing the Sort order setting. Below are instructions for changing the sort order for categories and products in your osCommerce store via Read More >
How to add a subcategory in osCommerce
After learning to add categories for your products, you may want to further divide them into subcategories. This article will explain how to create subcategories in osCommerce via the admin interface. Adding subcategory in osCommerce Log into your osCommerce admin interface. Under the left hand menu find and click the Catalog button. Click on the Read More >
How to add a new category in osCommerce
Adding categories and subcategories will help you to organize your products for your store. The instructions below will show you how to create new categories (and subcategories) from within your osCommerce admin interface. Adding a new category in osCommerce Log into your osCommerce admin interface. Under the left hand menu find and click the Catalog Read More >
Adding manufacturers in osCommerce
This tutorial will explain how to add a manufacturer to your osCommerce shopping cart. Manufacturers are important as they are where the products come from. To add a manufacturer in osCommerce, simply follow the steps below. How to add a manufacturer in osCommerce Log into your osCommerce admin interface. Under the left hand menu find Read More >
How to Install osCommerce via Softaculous
osCommerce is a free open-source for creating an online store. There are two ways to install this program into your hosting account, either manually, or via the softaculous installation tool. This article will guide you on the method of installing osCommerce with the Softaculous tool. Installing osCommerce via Softaculous Log into your cPanel interface. From Read More >
Learning the different data types in MySQL
When working with MySQL and its Structured Query Language (SQL), you may run across code where you need to undertand how it talks to the database. While SQL is a relatively simple language, knowing things such as data types will help you in your troubleshooting or coding. Below is a brief description of the main Read More >
How to determine the data type of a data column in phpMyAdmin
When working with SQL queries, either within your php code or when testing or toubleshooting errors via your phpMyADmin, it is helpful to understand the structure of the table you are writing to. If you are updating or adding new rows to tables, you will most definitely need to know the correct data type of Read More >
MySQL 1064 Error: You have an error in your SQL syntax
So, you’re creating a custom SQL query to perform a task in the database. After putting the code together and running it in PHPmyAdmin it responds with a 1064 error. It may look similar to this: The 1064 error displays any time you have an issue with your SQL syntax, and is often due to Read More >
How to embed video content in a WordPress site
When working with video content for your WordPress site, you have two options, uploading and embedding. You can learn the differences between the two in our article on Embedding vs Uploading Videos. This guide walks you through the process of embedding video content directly from a third party video site such as YouTube or Vimeo. Read More >
How to upload video content in WordPress
When working with video content for your site, you have two options, uploading and embedding. You can learn the differences between the two in our article on Embedding vs Uploading Videos. If you decided to upload the content to your WordPress site, follow the simple guide below. Uploading video content to your WordPress site Log Read More >
How to Create an Admin Account in WordPress via MySQL
When working with programs that require you to log in, such as WordPress, there can be times when you seem to be locked out of your account. This can happen via a code error, a hack, accidental admin account deletion, or a malicious site partner changing information on you. If this happens, you will need Read More >
Change the Max Upload File Size for a WordPress Multisite installation
When working with file uploads in WordPress a multisite configuration, you want to pay attention to the maximum upload file size. Allowing a setting that allows file sizes that are too large will cause performance issues. Below is a guide that explains how to change the maximum upload size. How to set the Max Upload Read More >
Finding the Network Administrator Interface for WordPress Multisite
When working with a WordPress MultiSite installation, the interface is just a bit different. This is because of the network setup. Below is a guide of how to locate the Network Admin interface after setting up a WordPress Multisite configuration. How to Login to the Network Admin in a WordPress MS Installation Log into to Read More >
How to Move WordPress from a Subfolder to the Root Directory
Many people like to create and test a new version of their site in a subfolder so that it does not affect their main domain. Once completed, they will want to migrate the new site over to the root directory for the domain. This is very common with WordPress. Follow the instructions below as we Read More >
An overview on moving applications from subfolders to your root folder
It is a common practice to test and/or build a new site version while maintaining the current version on the web. This way site visitors can continue to interact and the website business is not interrupted while the new content is designed or the software is tested. For this guide, we will be moving a Read More >
Overview on testing programs on your account
If you have an existing website and are thinking about switching to another type of program, it is a good idea to test different programs without interfering with your existing site. You can do this by installing the program you want to test into a subfolder. Once you have installed the program you can build Read More >
How to create and manage user ranks in phpBB 3.0
When working with users in your phpBB board site, you may wish to segregate users into different ranks. Ranks are simply titles that are achieved when a user has posted a specific number of posts. They are more or entertainment than anything and do not grant special privileges in and of themselved. In the instructions Read More >
