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