Insert not Inserting

[lmayer4]

Morning all,

I have an insert function that doesn't insert data. I would very much appreciate it if someone could take a look and tell me what I'm doing wrong...Thanks so much

<?php
$host = "HQMSITADMIN01";
$database = "Security";
$table = "tblHolding";

mssql_connect($host) or die("Cannot connect to the database.<br>");
mssql_select_db($database) or die("Cannot select the database.<br>");

function db_insert($table){
$query = "INSERT INTO ".$table." (";
$trigger = 0;
foreach($POST as $field => $value){
if($trigger > 0) $query = $query . ", ";
$query = $query . $field;
$trigger++;
}
$query = $query . ") VALUES (trim('";
$trigger = 0;
foreach($POST as $field => $value){
if($trigger > 0) $query = $query . ", trim('";
$query = $query . $value."')";
$trigger++;
}
$query = $query . ");";

//IF query runs, return. Else, tell me why
echo $query."";
if($result = mssql_query($query)) return(0);
else echo(mssql_error());
}
?>

[SpanKie]

At a quick glance, the problem seems to be with your below IF statement.

What is the variable $result, and what is its initial value. Your IF statement appears to be the trouble.

In your if statement, there should be a double equal sign to compare (==) if two values are the same.

Try something like this, much simpler:

mssql_query($query) or die(mssql_error());