Web Hosting Blog

Pixel Internet Web Hosting Blog

Possible issues with OSCommerce and MySQL5

Posted on 12/07/08, filed under Web Hosting Problems/Solutions | No Comments

We have been made aware that some customers may have issues with their OSCommerce installations after your recent upgrade to MySQL5.

To solve this, two files in the installation directory need to be changed. the first set of changes are needed to index.php.

Remove the code below from that file …

// show the products of a specified manufacturer
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific… Read full story


How do I query a MySQL database from a PHP script?

Posted on 12/07/08, filed under Hosting Tutorials | No Comments

In todays web hosting tutorial we are going to cover :

How do I query a MySQL database from a PHP script?

Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Remember if you are a Pixel Internet customer you cannot connect to your databases remotely for security reasons; you can only connect from localhost.

1. Connect to the… Read full story