<?php $server="localhost";
$ua="test";
$pwd="123456";
$conn=mysql_connect($server,$ua,$pwd,1,131072); //后面比平时多了1,131072表示本地化,这样才能返回记录集
mysql_select_db("test");
mysql_query("set names 'gbk'");
$re=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info=mysql_fetch_array($re); echo $player_info['p_name'];
$re2=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info=mysql_fetch_array($re2); echo $player_info['p_name'];
$db->close();
?>
$ua="test";
$pwd="123456";
$conn=mysql_connect($server,$ua,$pwd,1,131072); //后面比平时多了1,131072表示本地化,这样才能返回记录集
mysql_select_db("test");
mysql_query("set names 'gbk'");
$re=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info=mysql_fetch_array($re); echo $player_info['p_name'];
$re2=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info=mysql_fetch_array($re2); echo $player_info['p_name'];
$db->close();
?>
<?php $server="localhost";
$ua="test";
$pwd="123456";
$conn=mysql_connect($server,$ua,$pwd,1,131072); //后面比平时多了1,131072表示本地化,这样才能返回记录集
mysql_select_db("test");
mysql_query("set names 'gbk'");
$re=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info=mysql_fetch_array($re); echo $player_info['p_name'];
$re2=mysql_query("call prc_page_result(1, ‘*', test', 'p.u_id=c.u_id', '', 3, '', 1);");
$player_info2=mysql_fetch_array($re2); echo $player_info2['p_name'];
$db->close();
?>
$player_info2我改过名字
结果还是一样只显示第一个!!
第二个就错误