I'm a bit of a beginning to PHP, so I hope that this question isn't too terribly simple. I'm trying to write a flexible query that will use data from an HTML form to create a SELECT statement for a MSSQL database. I've tried writing a sample query, but I can't seem to get any data out of the database.
Here's my code:
from sqlmain.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<form action="ms_sql.php" method="get" name="main">
<input name="name" type="text">
<input name="submit" type="submit" value="Submit">
</form>
</body>
</html>
from ms_sql.php
$host ='mssql.library.univ.edu';
$user = 'LIB_webuser';
$pass ='######';
$db = 'LIB';
//Open connection
$connection = mssql_connect($host, $user, $pass) or die("Unable to connect");
//Select database
mssql_select_db($db) or die("Unable to select database");
//Create query
//$query = "SELECT * FROM dbo.dbd";
$name = $_POST['name'];
$query = "SELECT $name FROM bdb";
// Execute query
$result = mssql_query($query);
while($row = mssql_fetch_array($result)){
echo $row['netid'];
echo "<br />";
//free result set memory
mssql_free_result($result);
//close connection
mssql_close($connection);
Thanks for the help!
David
Unsolved 
