Problems with query change price in 2 tables

[Petje007]

thank you again dr. Byte, i had already see the mistake and changed that, but still not working

i do run this in phpMyAdmin

i have tryed somany solution the last 2 days, i am really frustrated

i don't know why it is not working

[DrByte]

I tested it here before I posted my first solution for you, and it works fine for me.
I can in phpMyAdmin that my products_price field is correctly updated with the new prices for me.
And then in my store if I run Admin->tools->store manager->reset products price sorter, my storefront will also show the new prices correctly.

So something must be wrong with your data. Perhaps your itemnumber values don't properly match your products_model numbers. Mismatched itemnumber-vs-products_model would cause a 0 price to be entered.

[Petje007]

When i start de query in Phpmyadmin, there is a message
i translate this message for you.

"there is missing a value in this form'

[DrByte]

When did that message start? Why didn't you mention it earlier?

[DrByte]

I just reconstructed a new table named inventory, added an itemnumber field and price field, using the same structure as the products_model and products_price fields in my zen_products table. Then I filled the inventory table with some sample entries, using itemnumbers that match products_model values.
I used phpMyAdmin to run the same query I posted above, and it worked without any error.

[Petje007]

because the second time i started the query in the startscreen (localhost » jvw_testdb) , i don't know how to tell you.

the first try with the query i was in the table inventory ( localhost » jvw_testdb » inventory) and after that i push the SQL button,
and start the query, there was no message and no changes in the prices

the last try with the message i was here in ( localhost » jvw_testdb) and started the same query, with result that message.

[Petje007]

i have found the problem why it is not working,

the field products_model in zen_products align to the left
the field itemnumber in inventory is floating?

How i don't know?

But now, how can i change the field itemnumber in inventory, also the the left?

thank you!

[Petje007]

Hello Dr. Byte, it's just like you said, it's working.

I don't no what's happened that at beginning of the field 'itemnumber' there were al lot of spaces.
I have removed the spaces and use this query from you:

update zen_products p, inventory i set p.products_price = i.price where p.products_model = i.itemnumber;

in 0,5 seconds more then 33000 prices were changed!. Is that not GREAT news

Thank you to point me at "So something must be wrong with your data. Perhaps your itemnumber values don't properly match your products_model numbers. Mismatched itemnumber-vs-products_model would cause a 0 price to be entered"

End yes, the data was mismatched.

Again Dr. Byte, thank you so much for your time and help!!