note 29875 deleted from ref.odbc by tix
| From: | tix@php.net | Date: | Thu, 27 Feb 2003 12:06:43 +0000 |
| Subject: | note 29875 deleted from ref.odbc by tix | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-44606@lists.php.net to get a copy of this message | ||
Ok,
Using ODBC, I can insert and select - fine. BUT when I try and use an update command, it dont work.
I works in other PHP scripts that conenct to my MS SQl database but I need to use ODBC know and it
dont work.
heres my script - any ideas?
<?php
$dbConnection = odbc_connect('ITREQUEST' , '$_SERVER[PHP_AUTH_USER]',
'$_SERVER[PHP_AUTH_PASSWORD]');
if (!$dbConnection)
{
exit("Unable to connect to database: $dbConnection");
}
$SQL_Exec_String = "Update requests (quotedHours)
VALUES
('$quotedHours')
WHERE request='$request'";
$dbConnection = odbc_exec( $dbConnection, $SQL_Exec_String );
echo '
';
print_r ("<B><U>IT Request Form Summary</U></B><br><br>
<B>Quoted Hours?:</B> $quotedHours <br>");
echo '
';
odbc_close($dbConnection);
?>
Any ideas?
Scott