Answer Posted / vijaya

we can always fetch from one database and rewrite to
another. Here is a nice solution of it.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);At this point you can only
fetch records from you previous ResultSet,

i.e $res1 - But you cannot execute new query in $db1, even
if you supply the link as because the link was overwritten
by the new db.so at this point the following script will fail

$res3 = mysql_query(”query”,$db1); //this will failSo how to
solve that?

Take a look below.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1″, $db1);
$res1 = mysql_query(”query”,$db1);

$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2″, $db2);
$res2 = mysql_query(”query”,$db2);

So mysql_connect has another optional boolean parameter
which indicates whether a link will be created or not. as we
connect to the $db2 with this optional parameter set to
‘true’, so both link will remain live.

now the following query will execute successfully.
$res3 = mysql_query(”query”,$db1);

How to genrate report in wordpress cms

2243

---

Tell me how to get the value of current session id?

879

---

What is the current stable version of php? What advance thing in php7?

958

---

What is substr in php?

965

---

How do you use end in python?

941

---

What are differences between PECL and PEAR?

981

---

What is a php web application?

961

---

what is the use of include_once in php?

994

---

How to get useful error messages in php?

1006

---

How to read one character from a file?

1033

---

Who is the father or inventor of php?

1023

---

Explain me what is the w3c?

1040

---

How could I install codeignitor ?

2141

---

What does the function get_magic_quotes_gpc() means?

880

---

What are the design patterns in php?

933

---