$LastName = "Smith"; if ($LastName != "") { // YOUR MSSQL 7.0 SERVER PARAMETERS $hostname = "192.168.1.1"; $username = "phpuser"; $password = "phpuser"; // YOUR MSSQL 7.0 DATABASE $dbname = "contacts"; // CONNECT TO THE MSSQL 7.0 DATABASE $connection = mssql_connect($hostname,$username,$password); mssql_select_db("$dbname"); $sql_query = "SELECT * FROM tbl_contacts WHERE LastName = '$LastName'"; $query_result = mssql_query($sql_query); $rs = mssql_fetch_array($query_result); mssql_close($connection); $inup = "u"; } else { $inup = "i"; } ?>
require("header.h") ?>