ODBC, PHP, IIS and UPDATE command dont work - help

slewis1972

Ok, I have some php pages running under IISv5 that connect to a MS SQl database via ODBC.

Now, select and insert statements work - great - BUT updates do not. If I use the query below and use a select or insert statement - it works. I have seached on phpbuilder - there was a simailar comment but no answer.

Any ideas?

Heres the code:-

<?php

$dbConnection = odbc_connect('ITREQUEST' , '$SERVER[PHP_AUTH_USER]', '$SERVER[PHP_AUTH_PASSWORD]');
if (!$dbConnection)
{
exit("Unable to connect to database: $dbConnection");
}

if($campaign == ''){
exit ("Please enter a campaign name");}

if ($quotedHours == "") {
$quotedHours = 0;}

$SQL_Exec_String = "Update requests (requester,email,campaign,
required, detail,objective,clientRequest,
quoted,quoteAccepted,quotedHours)
VALUES
('$_SERVER[PHP_AUTH_USER]',
'$email',
'$campaign',
'$required',
'$detail',
'$objective',
'$clientRequest',
'$quoted',
'$quoteAccepted',
'$quotedHours')
WHERE request='$request'";

$dbConnection = odbc_exec( $dbConnection, $SQL_Exec_String );

echo '
';
print_r ("IT Request Form Summary 
Request No: $request 
Name: $_SERVER[PHP_AUTH_USER] 
Email Address: $email 
Campaign: $campaign 
Required by?: $required 
Whats Required: $detail 
Objective: $objective 
Client Request: $clientRequest 
Quoted?: $quoted 
Quote Accepted?: $quoteAccepted 
Quoted Hours?: $quotedHours ");
echo '
';

odbc_close($dbConnection);

Scott
Previous Topic | Next Topic