getting mssql table information to excel

[udaykanth]

Am new bie to php mssql as well

Am trying to get a mssql table information to excel.

I have following coding.....

<?php

$myServer = "N3085";

$myUser = "sa";

$myPass = "sa";

$myDB = "examples";

 

//connection to the database

$dbhandle = mssql_connect($myServer, $myUser, $myPass)

or die("Couldn't connect to SQL Server on $myServer");

 

//select a database to work with

$selected = mssql_select_db($myDB, $dbhandle)

or die("Couldn't open database $myDB");

 

//declare the SQL statement that will query the database

$query = "SELECT * from oms";

 

 

//execute the SQL query and return records

$result = mssql_query($query);

 

$numRows = mssql_num_rows($result);

echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

 

//display the results

while($row = mssql_fetch_array($result))

{

echo "<li>" . $row["id"] . $row["name"] . $row["year"] . "</li>";

}

//close the connection

mssql_close($dbhandle);

?>

 

And i have been running dis php coding in wamp server

Am getting a error a undefined function mssql_connect() at line 15.

 

 

Thx in Advance

[Adam]

WAMP server must not have MSSQL support by default. This post appears to offer a solution (scroll to the last post), but there's no reply after so can't say if it works or not. Should be able to find something else on Google if not though.