cooperd

Sorry guys, it was my bad, I was working on this at the end of the day yesterday and didn't realize that I forgot to declare '$conn' in that function. Thanks for the reply's though.

Hi, I am trying to send data input in a form to the target page after it is submit, but using post or get doesn't seem to work because the data is not filled in when the input form is first loaded. Is there any way to get around this? Thanks, Dave

Hello, I am trying to query an SQL Server database from a php page. I am using the following code: $sql="SELECT [Adjust] FROM dbo.[ProjectData] WHERE ([ProjectNumber] = '".$_GET[pn]."')"; $res = mssql_query($sql, $conn); $row = mssql_fetch_assoc($res); echo sprintf($row["Adjust"]); This gives me a query value string SELECT [Adjust] FROM dbo.[ProjectData] WHERE ([ProjectNumber] = '1077') . When I execute this query in SQL Server Management Studio I get the correct result, but the above code is returning a null value. I know that my connection string is good. If anyone could help me out I would appreciate it. Thanks, Dave