Question

PHP高手进！

if(empty($username)||empty($password))
{
echo "<script>alert('请填好用户名和密码');history.back(-1);</script>";
exit;
}
$sql="insert into admin_user (username,userpass)values('$username','$password')";
$db->query($sql);
$last_id = $db->insert_id();

$result=$db->query($sql);
while($row=$db->fetch_array($result))
{
$group_id = check_str($row[group_id]);
$sql ="insert into user_provide(user_id,group_id)values('$last_id','$group_id')";
$db->query($sql);
}
----------------------------------------------------------------------------------
请问一下 这段程序中的两句SQL语句 怎么合并为一行？
不好意思 代码没贴全
if(empty($username)||empty($password))
{
echo "<script>alert('请填好用户名和密码');history.back(-1);</script>";
exit;
}
$sql="insert into admin_user (username,userpass)values('$username','$password')";
$db->query($sql);
$last_id = $db->insert_id();

$sql = "select * from user_provide where user_id = $user_id";
$result=$db->query($sql);
while($row=$db->fetch_array($result))
{
$group_id = check_str($row[group_id]);
$sql ="insert into user_provide(user_id,group_id)values('$last_id','$group_id')";
$db->query($sql);
}
-------------------------------------------------------------------------------
最后两句SQL怎么合为一句

Answer 1

insert into user_provide( user_id,group_id) select '$last_id',group_id FROM user_provide where user_id = '$user_id'
希望对你有用，呵呵