February 7, 2008 at 2:47 am
Hello
I wish to access already entered data in mssql from mysql. Something like this, in our website, member details are stored in mssql database, and I wish that customers don't need to sign in again from our mysql crm page, this crm page must access this member's profile details that already exists in our mssql database.
How can I write this code? Thanks.
February 7, 2008 at 9:39 am
Are you expecting your users to log in using Windows authentication? Are your users all within the same LAN? (I apologize - I left my MySQL books at home...)
February 7, 2008 at 11:27 pm
I've found this example, but I cannot tried this code because I'm on an another duty. Did this help me?
<?php
$sqlserver="SERVERNAME,2875"; // server name and port
$sqluser="USERNAME"; // user id
$sqlpassword="PASSWORD"; // password
$sqldb="DBNAME"; // database name
$msconnection=@mssql_connect("$sqlserver","$sqluser","$sqlpassword") ;
$msdb=mssql_select_db("$sqldb",$msconnection);
$msquery ="select * from TABLENAME where ID ='$avalue"; //query is here
$msresult= mssql_query($msquery);
if (mssql_num_rows($msresult) == 0){ echo "Entry cannot be found"; exit;}
while ($array = mssql_fetch_assoc($msresult))
{
$id= $array["ID"];
$value2= $array["value2"];
$value3= $array["value3"];
$value4= $array["value4"];
$value5= $array["value5"];
...
}
?>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply