Sedang Disiapkan

310646 select and insert query update

We have a script that tells us what items to pull down from a shelf to make up a product. We've changed db tables and names and need the script udated to the new info. Below is a list of items from a select statement that is no longer working.

Sku - should show from [url removed, login to view] (tied together by [url removed, login to view] = [url removed, login to view])

Name - should show from [url removed, login to view] (tied together by [url removed, login to view] = [url removed, login to view])

Lot # - should show from [url removed, login to view]

Qty - should show from [url removed, login to view]

Inventory - should show from [url removed, login to view] (tied together by [url removed, login to view] = pulling_herbs.lot_id)

We have checkboxes that we check once the item has been pulled fown from the shelf but after we made the changes they were all disabled and should not be if we have inventory. So we need this updated also to the new db fields.

Lastly when finishing the 'pulling' job it's updating some fields from pulling but 2 of them we don't want updated any longer. They are id, so right now it's adding 1 to the id but we need it to stay the same without adding 1. The last is product it currently has the id from the product table but is changing it to the item sku and we don't want that. The rest are fine.

I'll attach longer notes with code so you can see what your looking with. This shouldn't take very long and ask any questions on the message board and we'd like it finished pretty quickly. Thanks.

Kemahiran: Semua Boleh, MySQL, PHP

Lihat lagi: sku inventory, select, select item from, query table, info update, db query, mysql select statement, php insert select, disabled job, check table mysql script, insert mysql table, inventory update, query php product, need update working, mysql insert update , script update mysql tables, table inventory php script, inventory script php, tied together, script inventory php

Tentang Majikan:
( 95 ulasan ) Payson, United States

ID Projek: #2056443