mysql 不同步存储过程_php – MySQL存储过程导致`命令不同步’

调用程序在MySQL终端中可以正常工作,但在PHP中,导致命令不同步;你不能运行这个命令nowCommands不同步;你现在不能运行这个命令

我的程序是

delimiter $$

create procedure getMostSimilar (IN vU_ID INT, IN voffset INT, IN vsize INT)

BEGIN

set @offset = voffset;

set @size = vsize;

set @uid = vU_ID;

prepare SimilarStmt from

"SELECT U_ID, getSimilarity(U_ID, ?) AS similar FROM Answer WHERE U_ID != ? GROUP BY U_ID ORDER BY similar DESC LIMIT ?, ?";

execute SimilarStmt using @uid, @uid, @offset, @size;

deallocate prepare SimilarStmt;

END

$$

其中getSimilarity是一个函数.

在PHP中：

function getMostSimilar($U_ID, $offset, $size){

$query = sprintf("CALL getMostSimilar(%s, %s, %s)",

$U_ID, $offset, $size);

$result = mysql_query($query);

print mysql_error();

if (!$result){

return $query;

}

$ans = array();

$len = 0;

while($row = mysql_fetch_assoc($result)){

$ans[$len] = $row;

$len++;

}

return $ans;

}

我现在应该怎么做？谢谢！