Problems with query change price in 2 tables

[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!!

[DrByte]

:) Glad you got it sorted out.