troubleshooting Question

select form one host and then copy to another host

Avatar of teera
teera asked on
1 Comment1 Solution208 ViewsLast Modified:
$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
$sSql = "INSERT INTO onhandcheck (procode, proname, onhand, timestamp) (SELECT Code, Name, OnHand, NOW() FROM  prdmas WHERE OnHand != 0) ";
$rs = phpmkr_query($sSql,$conn) ;

How can i change the code above to  select data form host then insert in to host  all database table and user and pass word are the same fore 2 hosr only the difference is The host name

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros