No data in datyabase

dlhawkins69

This is my php script:
<?
#Make connection to inventory database as odin
$connection = odbc_connect("inventory", "odin","asgard");
#Set field values in the Computers table based on user input
$query = "INSERT INTO TEST (Product,OperatingSystem,SerialNumber) VALUES ('$Product_VersionNumber','$Product_OperatingSystem','$Product_SerialNumber')";
#Insert all data in test table
odbc_do($connection, $query);
echo "According to what you just entered ";
echo "'$employee' has a '$Product_VersionNumber' with $Product_OperatingSystem' installed, Serial Number is '$Product_SerialNumber'.";

echo "The serial number is $Product_SerialNumber.";
echo " Please continue on to the next machine and have a great

day.";
?>
<html>
<body>
<p><a href="http://172.30.110.49">Click here to
return</a></p>
</body>
</html>
The script runs because I get the have a nice day stuff, but no data is posted to the database. I dont get any errors. Can someone point me in the right direction on this one? I am using PHP 4.03 and SQL server 2000. Also, this worked at my last job so I know its possible.

nemonoman

What do you mean, you're not getting errors? Obviously the error occurs: nothing is being inserted. I don't know about SQL server 2000, but surely there is some way to check the error-code or status of the query similar to MySQL/PHP function:

mysql_error();

Check the equivalent SQL server 2000 function and post the results.

bradgrafelman

Indeed, there is a way to check for errors on an ODBC connection.

Change this:

odbc_do($connection, $query);

to this:

odbc_do($connection, $query) or die('Error, server said: ' . odbc_errormsg());

and let us know if you get an ugly error message outputted.