techker Posted October 5, 2010 Share Posted October 5, 2010 hey guys how would i be able to take a table and check in anoter table if it is there ..if not put like (o) if it is (1).. this checks the DB for the product SELECT TbItemInventory.Name, xcart_products.productcode, TbItemInventory.QuantityOnHand, xcart_products.avail,xcart_products.productid,TbItemInventory.ID,TbItemInventory.xcart FROM TbItemInventory, xcart_products WHERE ( TbItemInventory.Name = xcart_products.productcode ) Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/ Share on other sites More sharing options...
fenway Posted October 7, 2010 Share Posted October 7, 2010 What's "it"? Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/#findComment-1119916 Share on other sites More sharing options...
techker Posted October 7, 2010 Author Share Posted October 7, 2010 ? if it is in the catalogue DB set it to 1 if not set it to 0 Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/#findComment-1119958 Share on other sites More sharing options...
fenway Posted October 7, 2010 Share Posted October 7, 2010 Why can't you just check? Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/#findComment-1119969 Share on other sites More sharing options...
techker Posted October 7, 2010 Author Share Posted October 7, 2010 cause it is not me that will check every day when the update is done to check the products that were inserted and the one's that are missing... Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/#findComment-1120002 Share on other sites More sharing options...
fenway Posted October 8, 2010 Share Posted October 8, 2010 I mean why can't you script just check -- why maintain a flag that's always out of date? Quote Link to comment https://forums.phpfreaks.com/topic/215244-check-and-update/#findComment-1120182 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.