SQL & PHP
| From: | chris dot cranford at tkdsoftware dot com | Date: | Wed, 16 May 2001 17:01:13 +0000 |
| Subject: | SQL & PHP | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7625@lists.php.net to get a copy of this message | ||
All -
I am trying to execute an odbc_exec ($sql) command. A code example
is shown below:
$description = "Chris's Place";
$sql = "UPDATE SEARCH_RECORDS SET DESCRIPTION=\"".$description."\"";
// CX is already defined as a datbase connection
$stmt = odbc_prepare(CX, $sql);
if (odbc_execute($stmt)) { echo "Successful.": } else { echo
"Unsuccessful."; }
Why does the command:
UPDATE SEARCH_RECORDS SET DESCRIPTION="Chris's Page"
fail?
Thanks
Chris
PS -- Using a microsoft access 1997 database.