IF Else SQL Queries
Posted 01 March 2006 - 11:52 PM
In other words, If all 1500 PC screen is not sold, the item carry over to the next day until the inventory is sold out.
Table name: jos_vm_product <-- Need to check this table for
Column name: product_publish (Values: Y,N) <-- If [product_publish='Y'] check
Column name: product_in_stock (Values: "Empty_String" or Numerical Value) <-- If product_in_stock [IS empty] [UPDATE the Value of Column name: [product_publish='Y' TO product_publish='N']
Once the currently published item is unpublished (product_publish='N') then the Next item needs to be published. Primary keys is "product_id." I assume i would need to know the current "product_id" of the item to be "unpublished" so i can sequence the order of items next in line to be published.
This is killing me!
Any help would be appreciated.
Posted 02 March 2006 - 03:46 AM
Each product that's listed has a primary key (product_id). I guess i would need the "product_id" of the current item being unpublished and do ++ somehow to get the next product in line. I have no clue what i'm talking about here... so i could be 1000% wrong.
Posted 02 March 2006 - 03:02 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users