Compare MSSQL field with MySQL Field
Posted: Tue Dec 05, 2006 6:03 am
Hi I have the following connections which work
Lets say I want to match a field value "VSI_NUMBER" from"projects" (mySQL database) with
another field value "L_DN" from "fm60fil" (MSSQL database)
How would that be achieved?
Thanks
Geoff
Code: Select all
<?php
error_reporting(E_ALL);
//mySQL connection
$db_name="vsi_projects";
$connection=mysql_connect("localhost","root","***") or die("I Couldn't connect");
$db=mysql_select_db($db_name,$connection) or die("I Couldn't select your database");
$mytable="projects"; // Table name
//msSQL connection
$server="EU-SKE-SMS-01";
$username="administrator";
$password="***";
$db = "Adept_SQL";
$mstable = "fm60fil";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db($db,$sqlconnect);another field value "L_DN" from "fm60fil" (MSSQL database)
How would that be achieved?
Thanks
Geoff