mkosmosports Posted April 8, 2007 Share Posted April 8, 2007 Hey, Im thinking of the most effective way I could do an update of already exisiting mysql data through forms. So far, Im thinking my choices are: 1. Simply update all mysql fields regardless of if theyve changed or not. 2. Run some kind of a match (maybe preg_match) between the new form entry and the existing mysql entry. (Im not too familiar with this one) 3. Hoping someone from this forum can give me a push into the right direction... Thanks! mkosmosports Link to comment https://forums.phpfreaks.com/topic/46120-updating-already-existing-forms/ Share on other sites More sharing options...
AndyB Posted April 8, 2007 Share Posted April 8, 2007 Define 'most effective'. Updating all fields is easier to code. Link to comment https://forums.phpfreaks.com/topic/46120-updating-already-existing-forms/#findComment-224112 Share on other sites More sharing options...
mkosmosports Posted April 8, 2007 Author Share Posted April 8, 2007 Hmm...good question. By 'effective' I mean most logical, fastest. (maybe 'efficient' is the better word here) Not necessarily trying to make sure its easy code and it does seem like updating all fields regardless of changes is doing unnecessary work. Id also like to improve my php knowledge, so Id rather write the appropriate script regardless of its difficulty. Unless you think updating all fields in this case would be the preferred option after weighing out the overall pros and cons... Thanks Link to comment https://forums.phpfreaks.com/topic/46120-updating-already-existing-forms/#findComment-224114 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.