Variation of this script worked for MySQL, but not now for MSSQL

[badgoat]

So, I edited this script changing the parts which should hypothetically make it work with MS SQL... But it doesn't work. Is there something glaringly wrong or missing? It worked like a charm when I had everything coded for MySQL..

<?PHP

if(!empty($_REQUEST['action']) && $_REQUEST['action'] == 'update')
{
        $tc_case_id = $_REQUEST['tc_case_id'];
        $_GET['tc_case_id'] = $tc_case_id;
        $sqlquery = "UPDATE tad_casenum (tc_case_number,tc_forum_state, tc_county, tc_plaintiff, tc_defendant)  VALUES('". $_REQUEST['NEWtc_case_number'] ."','". $_REQUEST['NEWtc_forum_state'] ."','". $_REQUEST['NEWtc_county'] ."','". $_REQUEST['NEWtc_plaintiff'] ."','". $_REQUEST['NEWtc_defendant'] ."')";
        $result = mssql_query($sqlquery) or die("<b>msSQL Error:</b>".mssql_errono()."<br>".mssql_error());
        if(!$result)
        {
            echo 'Error processing request.';
        }
        else
        {
            echo '<B>The Record has been successfully updated!</B>';
        }
    }

$tc_case_id = $_GET['tc_case_id'];
	    // The ID is passed through the URL to specify the row,
// Or it is set in the previous script.

$query = "SELECT * FROM tad_casenum WHERE tc_case_id = '$tc_case_id'";
$result = mssql_query($query);
$row = mssql_fetch_array($result);

echo '<form name="update" method="post">
    <input type="hidden" value="update" name="action">
    <input type="hidden" name="tc_case_id" value="'.$tc_case_id.'">

<TABLE>
<TR>
    <TDUpdate Case Information</TD>
</TR>


<TR>
    <TD>Case Number:</TD>
	<TD><input type="text" name="NEWtc_case_number" size="45" value="'.$row['tc_case_number'].'"></TD>
</TR>

<TR>
    <TD>Forum State:</TD>
	<TD><input type="text" name="NEWtc_forum_state" size="45" value="'.$row['tc_forum_state'].'"></TD>
</TR>

<TR>
    <TD>County:</TD>
	<TD><input type="text" name="NEWtc_county" size="45" value="'.$row['tc_county'].'"></TD>
</TR>

<TR>
    <TD>Plaintiff:</TD>
	<TD<input type="text" name="NEWtc_plaintiff" size="45" value="'.$row['tc_plaintiff'].'"></TD>
</TR>

<TR>
    <TD>Defendant:</TD>
	<TD><input type="text" name="NEWtc_defendant" size="45" value="'.$row['tc_defendant'].'"></TD>
</TR>

<TR>
	<TD><input type="submit" value="Update"></TD></form>
</TR>

</TABLE>
';
?>

Did I mention that I am angry with my boss for refusing to budge off of MSSQL?

[thorpe]

are you getting any error?

[badgoat]

thorpe wrote:

are you getting any error?

No, but that may be my doing. With an earlier script I was bombarded with Warnings about an invalid index, but I thought I only turned off errors for that particular script. Looking in php.ini to make sure Ididn't turn off all errors.

Well, I don't have all errors turned off, (to the best of my rather noobish knowledge) and I am not getting any error

From my php.ini:

; - Show all errors except for notices and coding standards warnings
;
error_reporting = E_ALL; display all errors, warnings and notices

Should display them all, eh?

[Doug_G]

If tc_case_id is numeric, try removing the ' around the value in

$query = "SELECT * FROM tad_casenum WHERE tc_case_id = '$tc_case_id'";

[badgoat]

Thanks Doug for the suggestion.. Unfortuinately, it didn't work 🙁

Warning: MS SQL message: Line 1: Incorrect syntax near '('. (severity 15) in c:\phpdev5\www\admin\take-a-dep\case_information\ta_edit_case_info.php on line 22

Warning: MS SQL: Query failed in c:\phpdev5\www\admin\take-a-dep\case_information\ta_edit_case_info.php on line 22

Fatal error: Call to undefined function: mssql_errono() in c:\phpdev5\www\admin\take-a-dep\case_information\ta_edit_case_info.php on line 22

Got error messages turned on, these are the three I have.

If I change line 22 to:

$result = mssql_query($sqlquery);

The errors are:

Warning: MS SQL message: Line 1: Incorrect syntax near '('. (severity 15) in c:\phpdev5\www\admin\take-a-dep\case_information\ta_edit_case_info.php on line 22

Warning: MS SQL: Query failed in c:\phpdev5\www\admin\take-a-dep\case_information\ta_edit_case_info.php on line 22
Error processing request.

[Doug_G]

You might try inserting a debug statement like echo $sqlquery and see what the actual sql looks like. If you don't see an error in the sql yourself post it here.