Thanks Jeremy, I finally found the solution:
<?php
$query="SELECT * FROM DB1 JOIN DB2 ON DB1.dataid=DB2.dataid";
$queryupd="UPDATE DB1 SET dateval='20010101' where dateval='20000101'";
$hostname = "serverdb";
$username = "user";
$password = "pwd";
$dbName = "DB";
mssql_connect($hostname,$username,$password) or die("DATABASE FAILED TO
RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
$result2 = MSSQL_QUERY($queryupd); // Execute Update Statment
$result = MSSQL_QUERY($query); // Execute Select Statment
$number = MSSQL_NUM_ROWS($result);
$i=0;
if($number == 0) print "No data?";
elseif($number > 0){
print "Number of rows: $number<BR>";
while($i < $number){
$dateval= mssql_result($result,$i,"dateval");
echo "<TR><TD><FONT color=#112266>$dateval</FONT></TD>";
$i++;}
}?>
And it works fine !
Now I'm looking for the same function for IBM DB2 database connection...
Jerry
"Jeremy Reed" <[EMAIL PROTECTED]> wrote:
> What was the error message you received? Also, when passing the variables
> to the mssql_connect() function, you need not use quotes since you've
> already initialized them to the strings. Pass them as follows:
$connection
> = mssql_connect($a,$b,$c). Also, you aren't passing the actual sql string
> to the mssql_query() function. You have $sql = "blah" but you pass
> $sql_temp.
> Jerry wrote:
> > Hi
> > I have PHP on windows 2000 web server
> > I would like to remote to a MS SQL database on another web server.
> > I tried something like:
> > <?php
> > $h = "server adr";
> > $u = "user";
> > $p = "passw";
> > $b = "db";
> > $connexion = mssql_connect("$h", "$u", "$p");
> > mssql_select_db($b);
> > $sql_temp= "select * from test";
> > $result = mssql_query($sql_temp);
> > mssql_close($connexion);
> > ?>
> > But it didn't work. Please help me.
> > Jerry
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
