我得到以下错误:The active result for the query contains no fields
下面是我的代码
<?php
session_start();
include 'dbconnect_three.php';
include 'dbconnect.php';
include 'dbconnect_two.php';
$uname = $_SESSION['user'];
$email = $_SESSION['email'];
$message_id = $_POST['mess_id'];
$maxseq = $_POST['maxseq'];
$otheruser = $_POST['otheruser'];
//The part below is the one that does the query to retrieve the messages from the database
$sql_message_retriver = "SELECT message FROM inbox WHERE message_id='$message_id' ";
$sql_message_retriever_result = sqlsrv_query($conn_three, $sql_message_retriever);
while ($sql_message_result_display = SQLSRV_FETCH_ARRAY($sql_message_retriever_result, SQLSRV_FETCH_ASSOC)) {
$message_string = $sql_message_result_display['message'];
echo "<right>$message_string</right>";
}
$seen = 2;
$maxseq = $maxseq + 1;
echo "<form action=// method=post>";
echo "Messageinput type=text name=update>";
echo "<input type=hidden name=message_id value=$message_id>"; // gotta fix this part
echo "<input type=hidden name=maxseq value=$maxseq>";
echo "<input type=hidden name=otheruser value=$otheruser>";
echo "<input type=hidden name=otheremail value=$otheremail>";
echo "<input type=hidden name=keyes value=$keyes>";
echo "<input type=submit name=submit value=Reply>";
echo "</form>";
print_r(sqlsrv_errors());
?>
我得到的确切错误:
Array (
[0] => Array (
[0] => IMSSP
[SQLSTATE] => IMSSP
[1] => -28
[code] => -28
[2] => The active result for the query contains no fields.
[message] => The active result for the query contains no fields.
)
)
以下是我从其他论坛找到的一个解决问题的建议:使用sqlsrv_next_result
。我用过它,它说ODBC函数序列错误(类似的)。
当我把sql语句改成这样时,需要注意的是:
$sql_id_two="SELECT message
FROM inbox
WHERE message_id = '$message_id'
AND to_email = '$email'
OR from_email = '$email'";
它实际工作并显示消息。这很奇怪。
有人能解释这个错误消息吗?
在我的例子中,使用PDO,我不得不调用nextRowset(),因为我试图从insert
的结果中读取列,然后再读取select
。
SQLSRV等效为:
mixed sqlsrv_next_result ( resource $stmt )
我发现了问题所在,我的sql语句出现了拼写错误。因此,我为sqlsrvquery的资源2插入了错误的拼写。我怎么能这么笨。