从数据库中删除 [英] delete from database

问题描述

我的代码不会从数据库中删除。相同的代码（在同一个文件中粘贴一个

粘贴，但功能不同，查询不同）

有效。所以，当然，我以交互方式测试了查询。我回应了查询

，并在交互式连接到数据库时进行了剪切和粘贴。那个

一个工作，所以这不是查询，因为交互式它看到的确是

与代码产生的相同。


以下是代码：


函数deleteCatalog（$ catalog）{

$ query =" DELETE FROM CatalogNames WHERE sCatalogID =''" 。 $目录。 "'''";

mssql_select_db（$ database_Login，$ _SESSION [''Login'']）;

$ result = mssql_query（$ query，$ Login） ;

...

}


$ query回声：

DELETE FROM CatalogNames WHERE sCatalogID =''CMP''


作为代码的一个例子（在同一个文件中）

函数addToCatalog（$ cat_id，$ cat_name）{

$ query =" INSERT INTO CatalogNames（sCatalogID，sCatalogName）" 。

" VALUES（''"。$ cat_id。"''，''"。$ cat_name。"''）" ;;

mssql_select_db（$ database_Login，$ _SESSION [''Login'']）;

$ result = mssql_query（$ query，$ _SESSION [''Login'']）;

...

}

第二行和第三行与其他地方相同（剪切和粘贴）

在同一代码中。实际上，只有在这个文件中我才能完成所有的数据库工作。每个其他功能都有效。这是唯一的删除，

但是。


有什么想法吗？


Shelly

I have code that does not delete from a database. The same code (cut an
paste in the same file, but different function and having a different query)
works. So, of course, I tested the query interactively. I echoed the query
and did a cut and paste when interactively connect to the database. That
one worked so it isn''t the query since interactively it is seeing exactly
the same thing as the code produces.

Here is the code:

function deleteCatalog($catalog) {
$query = "DELETE FROM CatalogNames WHERE sCatalogID=''" . $catalog . "''";
mssql_select_db($database_Login, $_SESSION[''Login'']);
$result = mssql_query($query, $Login);
...
}

The $query echos:
DELETE FROM CatalogNames WHERE sCatalogID=''CMP''

As an example of code that works (in the same file)
function addToCatalog($cat_id, $cat_name) {
$query = "INSERT INTO CatalogNames (sCatalogID, sCatalogName) " .
"VALUES (''" . $cat_id . "'', ''" . $cat_name . "'')";
mssql_select_db($database_Login, $_SESSION[''Login'']);
$result = mssql_query($query, $_SESSION[''Login'']);
...
}
The second and third lines are identical (cut and pasted) as in other places
in the same code. In fact, it is only in this file that I do all the
database work. Every other function works. This is the only delete,
however.

Any ideas?

Shelly

推荐答案

catalog）{

catalog) {

query =" DELETE FROM CatalogNames WHERE sCatalogID =''" 。

query = "DELETE FROM CatalogNames WHERE sCatalogID=''" .

目录。 "'''";

mssql_select_db（

catalog . "''";
mssql_select_db(

这篇关于从数据库中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！