svalowden Posted June 25, 2008 Share Posted June 25, 2008 I'm pretty new to PHP and MySQL but I've downloaded some scripts and have almost everything working pretty well. My problem is that I have a users table linked to a profile table through the email column. What I want to do is allow a logged in user to update the profile table. When I do a join of the two tables I can display all of the data in either table but I can't update any of the data. The tables update fine individually. Is JOIN the way to do it or is there some other way? I'm using MySQL v4.1. Link to comment https://forums.phpfreaks.com/topic/111930-theory-behind-updating-a-table-based-on-a-key-from-another-table/ Share on other sites More sharing options...
rhodesa Posted June 26, 2008 Share Posted June 26, 2008 you have to update the tables individually Link to comment https://forums.phpfreaks.com/topic/111930-theory-behind-updating-a-table-based-on-a-key-from-another-table/#findComment-574564 Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 What are you trying to update that's in both tables? I'm confused. Link to comment https://forums.phpfreaks.com/topic/111930-theory-behind-updating-a-table-based-on-a-key-from-another-table/#findComment-574740 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.