If you use MySQL, instead of INSERT, do a REPLACE--they use the same syntax. Read about it here: http://www.mysql.com/doc/en/REPLACE.html
On Tue, 2002-05-21 at 00:32, Markus Lervik wrote: > > Hello all, > > How do you people solve the problem of multi-table updates? > > Consider the following scenario: > You got a php-program that has, say, ten fields. > You got your database that has it's data normalized (as the > good database designers we all are *grin*) and split up over, > say, four tables. > Now, if you want to check that some of the info in the fields > are already there, how do you go about it? > > A practical example. > I've got a database of our computers. The database contains > name (fqdn), ip-address, mac-address, network, what switch/hub it's > connected to, rough location (ie, floor), accurate location (ie. what > room) etc. > > I've got a php-program with the above-mentioned fields. > I've got a ip_name_tbl table, a location table, a ac_loc table > and a hub_switch_tbl. I wan't to check that the information entered > isn't already in the database tables, but I want to be able to add, > say, two ip-addresses for the servers etc. > > The way I solve it now is i SELECT name and other that I want to be > unique and see if I get anything. If not, add. If it's there, don't. > > Obviously there's a problem with my approach: For each computer > inserted, there's a minimum of four or five SELECTs and four or > five INSERTs. > > I'm positive some of you have similar problems. How do you go > about solving it? > > > Cheers, > Markus Lervik > > > -- > > Markus Lervik | A Microsoft Certified Systems > Linux-administrator | Engineer is to computing what > Vaasa City Library - Regional Library | a McDonalds Certified Food > +358-6-325 3589 / +358-40-832 6709 | Specialist is to fine cuisine > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
