Question

php 调用mysql存储过程

// $sql = "SELECT spda.dnm,spmc FROM a_spda spda left join a_tm tm on spda.dnm=tm.dnm OR tm.tm like '%" .$keyword. "%' where spmc like '%"

.$keyword. "%' or spda.dnm like '%" .$keyword. "%' limit 20 ";//or tm.tm like '%" .$keyword. "%'
$sql = "call wg_spda_dear('".$keyword."')";
$result = mysql_query($sql,$con);//执行SELECT查询
while($res = mysql_fetch_array($result, MYSQL_ASSOC) )
{
$contentStr1 .= $res['spmc'] . $res['dnm']."\r\n";

}
如上，直接使用sql语句就可以，用存储过程就不行，求解决方案

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

<bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
configure:3427: gcc --version >&5
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.11.00)
Copyright (C) 2007 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.