note 29875 added to ref.odbc
| From: | slewis1972 at hotmail dot com | Date: | Thu, 27 Feb 2003 11:01:15 +0000 |
| Subject: | note 29875 added to ref.odbc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-44603@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
--
http://www.php.net/manual/en/ref.odbc.php
http://master.php.net/manage/user-notes.php?action=edit+29875
http://master.php.net/manage/user-notes.php?action=delete+29875
http://master.php.net/manage/user-notes.php?action=reject+29875