Help With SQL

[LordGemz]

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

[DrByte]

Um ... an ALTER TABLE statement requires that you use the *entire* statement. I have no idea why you would use only the part after the "ADD".
Use the whole line.

[LordGemz]

thank you Dr. that worked great, and you have a zenned day.