Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

Hi

 

I am pretty new to all this, as so am consequently a bit thick.

 

Can someone tell me please how I do the following.

 

Database

--------

You will have to add an extra field to the customers table of the data base

 

ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL;

 

I haven't got a clue except its in MySql

 

Many thanks

 

Grandpaj

Posted (edited)

John,

 

 

 

Log into your hosting account and look for the database area.

 

 

Open myphpadmin for that database and you will see the tables for your store.

 

MAKE A BACK UP OF YOUR DATABASE NOW !!! (EXPORT A COPY TO YOUR LOCAL MACHINE)

 

Click the SQL tab and paste that code into the box..........click GO

 

If it says SUCCESSFUL, you have altered the tables to add the column for that contribution.

 

 

Chris

Edited by DunWeb

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...