Page 2 of 2
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Wed Aug 19, 2009 10:03 am
by tomex1
Hi Juma929,
I absolutely agree that JOIN can do this but that's if the two tables are in the same database I guess?
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Thu Aug 20, 2009 12:30 am
by mrvijayakumar
Hello tomex1,
Brilliant question, for this, write update query with where clause to fetch record with unique primary key dear. Try it out. Come out with more questions. We can fix it..
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Thu Aug 20, 2009 6:11 am
by mrvijayakumar
Hi,
Replace this, and i dont kno about derby.
if($k == $v) {
//mysql_query(); //update the table 2 value by using
using query
print "EQUAL";
}
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Thu Aug 20, 2009 6:16 am
by mrvijayakumar
If not working fine means, send me entire code to my mail box. I will check it and reply u back.
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Thu Aug 20, 2009 6:19 am
by juma929
Hello,
Sorry been swamped. You definatly can use joins from different databases but im used to working
primarily in MySQL / MSSQL so im not sure about Derby. It may be worthwhile taking what im saying on the matter with a pinch of salt until proven otherwise due to this.
Do a little research on Derby's join abilities, in MySQL something like the following is easily possible:
SELECT db1.table1.field1, db2.table2.field2 FROM db1.table1, db2.table2 WHERE db1.table1.field1 = db2.table2.field2 ETC...
Thanks

Re: Help on iterating 2 arrays and also comparing the values?
Posted: Thu Aug 20, 2009 12:09 pm
by tomex1
Hi Juma929,
Thanks. I definitely will have a look at Derby's join capabilities.
Cheers
Re: Help on iterating 2 arrays and also comparing the values?
Posted: Sun Aug 23, 2009 11:24 am
by tomex1
Hi mrvijayakumar,
your code does works!!!
Thanks