php - Connetions with another database and server on subquery -

-

how can connect db1, server1 sub query ? thanks!

$link1 = mysql_connect("server1","user1","pas1"); mysql_select_db('db1', $link1); $link2 = mysql_connect("server2","user2","pas2") or die(mysql_error()); mysql_select_db("db2", $link2) or die(mysql_error());  $sql="select db2.`e`.`entity_id` , db2.a.value klantnr, db2.b.value    voornaam,db2.c.value achternaam, db2.`t`.`value` telfnr, db2.ce.email     db2.`tablename` e left outer join db2.customer_entity_varchar on db2.a.entity_id = db2.e.parent_id , db2.a.attribute_id = '133' db2.ce.email not in(select db1.email_addresses.email_address db1.tablename) , db2.a.value in (select db1.accounts_cstm.custid_c db1.accounts_cstm ) group db2.ce.email"; $result = mysql_query($sql,????) or die(mysql_error());

i have solution (way) error(operand should contain 1 column(s))

$link1 =mysql_connect("server1","user1","pas1"); mysql_select_db('db1', $link1); $link2 = mysql_connect("server2","user2","pas2") or die(mysql_error()); mysql_select_db("db2", $link2) or die(mysql_error()); $query="select email_addresses.email_address db1.tablename"; $result = mysql_query($query,$link1) or die(mysql_error());  $select=array(); $row=mysql_fetch_array($result); $select[]=$row["email_address"]; $select = "('" . implode ("','", $select) . "')"; mysql_query("set     sql_big_selects=1",$moonen_link);  $sql="select `e`.`entity_id` , a.value klantnr, b.value voornaam, c.value achternaam, `t`.`value` telfnr, ce.email `tablename` e left outer join customer_entity_varchar on a.entity_id = e.parent_id , a.attribute_id = '133' ce.email not in($select) group ce.email"; $result = mysql_query($sql,$link2) or die(mysql_error());

i think "user1" should have access (privilege) both database if on same mysql server.

then connect 1 database with

$link1 = mysql_connect("server1","user1","pas1"); mysql_select_db('db1', $link1);

and request on both server $link1:

 $sql="select db2.`e`.`entity_id` , db2.a.value klantnr, db2.b.value     voornaam,db2.c.value achternaam, db2.`t`.`value` telfnr, db2.ce.email     db2.`tablename` e left outer join db2.customer_entity_varchar on db2.a.entity_id = db2.e.parent_id , db2.a.attribute_id = '133' db2.ce.email not in(select db1.email_addresses.email_address db1.tablename) , db2.a.value in (select db1.accounts_cstm.custid_c db1.accounts_cstm ) group db2.ce.email"; $result = mysql_query($sql,$link1) or die(mysql_error());

should ok


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more