I have installed the MRSP addon and in thread http://www.zen-cart.com/forum/showth...highlight=msrp
it says to add to the sql tools in the admin area i did then I tried the phpmyadmin and got the same message error
Error

SQL query:

`products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price`

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price`' at line 1

for the SQL i am using

1. Add a new field to the products table to hold the MSRP value.

ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;
 <-------the code in red is what I use, is this correct?
the rest is for the stylesheet
2. In includes/templates/your_template/css/stylesheet.css, or includes/templates/classic/css/stylesheet.css

Add:

.smalltext1 {
font-family:Tahoma;
text-align: center;
color:#FFFF00;
font-weight:bold;
}

.save {
font-family:Tahoma;
text-align: center;
color:#00FFFF;
font-weight:bold;
}

.norm {
font-family:Tahoma;
text-align: center;
color:#FF0000;
font-weight:bold;
}

some help or ideas would be great