chrometweaks.org

I cannot get my website on iPage.com to work....please help?

Click Here To View All Answers...


Got a question... I cannot get my website on iPage.com to work....please help? Thanks in advance for any comment. Second question of mine... I need to alter a group of entries in the products table. I've never done this before and this is a live shop so I want to be as sure as possible before doing this. Here's the first line of the sql file I plan on using:.

UPDATE products SET products_discount_1 = '1.0' WHERE products_model >= '1000' AND products_model_1 < 2000;.

My intent is to set the products_discount_1 field to 1.0 for all items that have a model number from 1000 to 1999. Does this look like it will work?.

Jack..

Comments (10)

I would like to know the answer too. Anyone here know what is the right answer. I'll do some research and get back to you if I discover an useful answer. You should email the people at iPage as they probably could help you..

Comment #1

Looks good to me - make a copy of the products table into your existing DB - run the query and if it goes wrong just re-copy the table..

This post has been edited by.

Yesudo.

: 09 May 2004, 21:42..

Comment #2

Or is it:.

UPDATE products SET products_discount_1 = '1.0' WHERE products_model_1 >= '1000' AND products_model_1 < 2000;..

Comment #3

John - I did check the syntax and it seemed fine but, like I said, this is a live shop so I didn't want to go editing things without some assurance. I've ran into a previous problem where I was installing a contribution and it took out my entire db. Several hours passed before I was back up. No way I want to go through that again..

Out of curiosity, how do I run the sql code on the database when it is on my hard drive? I'm guessing I have to have mysql installed?.

Jack..

Comment #4

Thanks for the suggestion. I didn't know I could do this. I made a copy and tested as you suggested and everything went fine. I appreciate the help..

Jack..

Comment #5

I need to alter a group of entries in the products table. I've never done this before and this is a live shop so I want to be as sure as possible before doing this. Here's the first line of the sql file I plan on using:.

UPDATE products SET products_discount_1 = '1.0' WHERE products_model >= '1000' AND products_model_1 < 2000;.

My intent is to set the products_discount_1 field to 1.0 for all items that have a model number from 1000 to 1999. Does this look like it will work?.

Jack..

Comment #6

Did you check the mysql.com iPage site for the proper syntax?.

Also, download a copy of the database and then run the sql code on it?.

Or copy the database to another one on the server ,and try it there...

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.