更新查询无效 - 需要查看[关闭]

Question

Can anyone tell where am I wrong in the query. The database in not updating irrespective of the value

<?php

// ================= UPDATE =========================
if ($_POST['SUBMIT']=='SUBMIT')
{
    $fixture_id = "$_GET[id]";
    $m_date = "$_POST[match_date]";
    $m_time = "$_POST[match_time]";
    $m_report = "$_POST[match_report]";
    $m_a_result = "$_POST[team_a_result]";
    $m_b_result = "$_POST[team_b_result]";

$updt = mysql_query("UPDATE `fixture` SET match_date='$m_date', match_time='$m_time', match_report='$m_report', match_a_result='$m_a_result', match_b_result='$m_b_result', status = 1 WHERE id = '$fixture_id'");

header("location:view_fixture.php?msg= You have inserted result successfully...");              

}
else
{
header("location:result_update.php?msg= Something went wrong...");              

}

// ================================================================================
?>

Answer 1

Before executing this make sure your submit button have a string value of "SUBMIT"

Try this ..

<?php

    $fixture_id = $_GET[id];

if ($_POST['SUBMIT']=='SUBMIT')
{
    $m_date = $_POST['match_date'];
    $m_time = $_POST['match_time'];
    $m_report = $_POST['match_report'];
    $m_a_result = $_POST['team_a_result'];
    $m_b_result = $_POST['team_b_result'];

$updt = mysql_query("UPDATE `fixture` SET match_date= '$m_date', match_time='$m_time', match_report='$m_report', match_a_result='$m_a_result', match_b_result='$m_b_result', status = 1 WHERE id = '$fixture_id'");

header("location:view_fixture.php?msg= You have inserted result successfully...");              

}
else
{
header("location:result_update.php?msg= Something went wrong...");              

}


?>

Please DO NOT USE mysql_* . It is now deprecated