Creating a dynamic query using MSSQL and PHP

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 "";

//free result set memory

mssql_free_result($result);

//close connection

mssql_close($connection);

Thanks for the help!

David

daver40

Newbie Poster

6 posts since Oct 2007

Reputation Points: 10

Solved Threads: 0

4 Years Ago

0

try this:
$name = $_REQUEST['name'];

fatihpiristine

Posting Whiz in Training