termn8r Posted September 18, 2007 Share Posted September 18, 2007 I have been doing this by using a php file for years on several different tables and know this must be one of the clunkiest ways to do this and instead of researching for days to try to find the answer I thought I would just ask. I figure this is a super easy thing to do once you know how. Old_Table ID,name,category,status,details New_Table ID,name,category,status,details,date_entered,date_updated I want to update the Category of New_Table with Old_Table category IF New_Table Category = "" Another example would be: Master_Table ID,name,address,category,status,details,date_entered,date_updated,end_date Sub_Table SID,name,address,details,date_entered,date_updated,end_date I want to add to Master_Table with Sub_Table data only if the data is NEW OR status on Master (of identical address or at least 95% close) isn't set to "Never" then I want to update end_date of now. Is there a way to do these 2 queries as an actualy query? Or is my clunky way of making a php file to cross reference about the best way to check? Quote Link to comment https://forums.phpfreaks.com/topic/69794-cross-referencing-one-table-with-other-and-updating-via-certain-rules/ Share on other sites More sharing options...
fenway Posted September 19, 2007 Share Posted September 19, 2007 You can "convert" a multi-table select into a multi-table update... Quote Link to comment https://forums.phpfreaks.com/topic/69794-cross-referencing-one-table-with-other-and-updating-via-certain-rules/#findComment-351351 Share on other sites More sharing options...
termn8r Posted September 20, 2007 Author Share Posted September 20, 2007 Can you show me an example? Quote Link to comment https://forums.phpfreaks.com/topic/69794-cross-referencing-one-table-with-other-and-updating-via-certain-rules/#findComment-351560 Share on other sites More sharing options...
fenway Posted September 21, 2007 Share Posted September 21, 2007 Do you have a working select statement? Quote Link to comment https://forums.phpfreaks.com/topic/69794-cross-referencing-one-table-with-other-and-updating-via-certain-rules/#findComment-352391 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.