glennn.php Posted April 25, 2007 Share Posted April 25, 2007 i have a db with two tables, product_id and product_image, in that order, about 480 records. i'd LOVE IT if there was a way to export this table/query so as to get - UPDATE product_image = 'x' WHERE product_id = 'y'; anybody? many thanks --- gn Quote Link to comment https://forums.phpfreaks.com/topic/48697-export-update-with-a-where-clause/ Share on other sites More sharing options...
Wildbug Posted April 25, 2007 Share Posted April 25, 2007 What do you mean export/update? Quote Link to comment https://forums.phpfreaks.com/topic/48697-export-update-with-a-where-clause/#findComment-238633 Share on other sites More sharing options...
bubblegum.anarchy Posted April 26, 2007 Share Posted April 26, 2007 Use table joins just like a normal select statement. Quote Link to comment https://forums.phpfreaks.com/topic/48697-export-update-with-a-where-clause/#findComment-238746 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.