RE: [PHP] Re: How to UPDATE two MySQL Tables

2002-07-27 Thread John Holmes
> You can use REPLACE instead of making two separate queries (UPDATE and > INSERT) because it checks if it is there, and if it's not, then it adds > it; > otherwise it updates it. I think that's right ... but the SQL server's > SQL > server is broken! (the irony!) Just note that REPLACE is MySQL

[PHP] Re: How to UPDATE two MySQL Tables

2002-07-27 Thread Chris Earle
You can use REPLACE instead of making two separate queries (UPDATE and INSERT) because it checks if it is there, and if it's not, then it adds it; otherwise it updates it. I think that's right ... but the SQL server's SQL server is broken! (the irony!) That won't solve all of your problems, but