<?php
include("conn.php"); //引入数据库连接文件$qqgonghao=$_GET['qqgonghao'];//GET参数为空的时候,为取号,不为空的时候,更新数据
if(!empty($qqgonghao))
{
$result=mysql_query('select * from qqlist where qqgonghao like "8889" LIMIT 1');
if($row=mysql_fetch_array($result))
{
mysql_query('UPDATE qqlist SET qqgonghao = "'.$qqgonghao.'" WHERE qquin = "'.$row['qquin'].'"');
echo $row['qquin']."----".$row['qqpass'];
}} else {
}
// 释放资源
mysql_free_result($result);
// 关闭连接
mysql_close($conn);
?>
以上写法在并发情况下,就会重复了,不知有何最可取的办法?
include("conn.php"); //引入数据库连接文件$qqgonghao=$_GET['qqgonghao'];//GET参数为空的时候,为取号,不为空的时候,更新数据
if(!empty($qqgonghao))
{
$result=mysql_query('select * from qqlist where qqgonghao like "8889" LIMIT 1');
if($row=mysql_fetch_array($result))
{
mysql_query('UPDATE qqlist SET qqgonghao = "'.$qqgonghao.'" WHERE qquin = "'.$row['qquin'].'"');
echo $row['qquin']."----".$row['qqpass'];
}} else {
}
// 释放资源
mysql_free_result($result);
// 关闭连接
mysql_close($conn);
?>
以上写法在并发情况下,就会重复了,不知有何最可取的办法?
select * from qqlist where qqgonghao like "8889" LIMIT 1 for update