Query help

Poll

Has Hilco abandoned this site?

Yes?

50%

No?

17%

I can't tell!

33%

Total votes: 6

Login to post comments
Older polls

User login

New forum topics

Active forum topics

2 replies [Last post]

Fri, 06/26/2009 - 12:47

planb

Joined: 04/28/2008

Points: 30

I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by a certain percenatge. The products all have a code starting with the letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and so on. I may only have to update the dcc prices one month, and the ffc the next. I need to know the UPDATE query to be able to do this.

The product codes are in a column called p_code and the prices that need to be updated are in a column called p_prices.

I need to run an UPDATE query in PHPMYADMIN. ... can anyone help?

Kevin

Tue, 06/30/2009 - 21:48

Hilco

Joined: 02/25/2008

Points: 378

I suggest you create a php

I suggest you create a php script for doing so, just select all products you want to update first, then run a query for each product to update it using php. It's a bit saver than an update query, because when you fail one, your database is messed up and that's not undoable.

Select all products you want to change price for
use php to calculate new price
run a query to update productprice using php

Wed, 07/01/2009 - 07:49

planb

Joined: 04/28/2008

Points: 30

php to update prices

Thanks Hilco,

That's ok if I knew PHP, which I dont, so where do I start to look for the code is there a video. I have watched the core training already so I know that much but dont know where to start with creating the script.