时间戳

首页 > 解决方案 > Updation not happening in the first click

php - Updation not happening in the first click

问题描述

I am fetching the values from data table to allotted table and name from attendents table. I am able to get values from data on submit but getting name on submitting second time. Here is my sql query code: 

    $allot = "SELECT id from data ORDER BY id desc";
    $all = mysqli_query($link,$allot);
    $id3 = mysqli_fetch_assoc($all);
    $id3 = $id3['id'];
    echo $id3;


    $sql = "INSERT INTO allotted (id,pickup_loc,pickup_ward,drop_loc,drop_ward,task)
    SELECT id,pickup_loc,pickup_ward,drop_loc,drop_ward,task
    FROM data ORDER BY id desc LIMIT 1";


       $query3 = "SELECT attendants_name FROM attendents WHERE id = '$id'";
       $result3 = mysqli_query($link,$query3);
       $id2 = mysqli_fetch_assoc($result3);
       $id2 = $id2['attendants_name'];
       print_r($id2);
       $update_name = "UPDATE allotted SET attendants_name = '$id2' WHERE id = '$id3'";
       $check1 = mysqli_query($link,$update_name);

标签： phpmysqlsql

解决方案

$id2 = mysqli_fetch_assoc($result3);

$id2 = $id2['attendants_name'];

print_r($id2);

你在这里得到什么输出？它是文本还是数组？请检查。

希望这会奏效。

推荐阅读