Thanks Jeremy, I finally found the solution:
0){
print "Number of rows: $number";
while($i < $number){
$dateval= mssql_result($result,$i,"dateval");
echo "$dateval";
$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:
> > > $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 Database 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]