第一行数据库数据在一段时间后没有更新 [英] First row of database data not updating after some time

问题描述

我正在使用在PHP中创建的表单。首先，我从DB获取两行，我使用表单向他们提交值。我对他们两个使用相同的表格。这些值进入数据库，但在一些点击后第一行停止更新。我不知道发生了什么。



我包含了我的问题视频。 - > http://www.youtube.com/watch?v=uTFzfmJh8jU [ ^ ]

I'm using a form created in PHP. First I am getting two rows from the DB which I submit values to them using the form. I am using the same form for both of them. The values go into the DB but after some clicks the first row stops updating. I don't know what's going on.

I include a video of my problem. -->http://www.youtube.com/watch?v=uTFzfmJh8jU[^]

<?php
    session_start();
    include("connect.php");

    $query = "SELECT * FROM test ORDER BY `id` ASC LIMIT 2";
    $result = mysql_query($query);

    echo "<h2>Seria A</h2><hr/>";

    while($row = mysql_fetch_array($result)) {

        $id = $row['id'];
        $home = $row['home'];
        $away = $row['away'];
        $win = $row['win'];
        $draw = $row['draw'];
        $lose = $row['lose'];

        echo "<br/>",$id,") " ,$home, " - ", $away;
        echo "  
        <form action='seria.php' method='post' id='$id'>
            <input type='radio' name='select' value='1'>1
            <input type='radio' name='select' value='X'>X
            <input type='radio' name='select' value='2'>2
            <input type='hidden' name='id' value='".$row['id']."'/>
            <input type='submit' name='submit<?php echo $id; ?>' value='Submit'/>
    <br/>
        </form>";            

        echo "Totali ", $sum = $win + $lose + $draw, "<br/><hr/>"; 
    } 

    if (!empty($_POST)) {
        $id=isset($_POST['id'])&&is_numeric($_POST['id']) ? $_POST['id']:false;
        $select = isset($_POST['select']) ? $_POST['select']:false;

        switch ($select) {
            case 1:
            $select = $win + $select;
            mysql_query("UPDATE test SET win='$select' WHERE id='$id'");
            break;

            case 'X':
            $select = '1';
            $select = $draw + $select;
            mysql_query("UPDATE test SET draw='$select' WHERE id='$id'");
            break;

            case 2:
            $select = '1';
            $select = $lose + $select;
            mysql_query("UPDATE test SET lose='$select' WHERE id='$id'");
            break;

            default:
        }
        header('Location: ../seria.php');
    }
?>

推荐答案

查询 = SELECT * FROM test ORDER BY`id` ASC LIMIT 2;

query = "SELECT * FROM test ORDER BY `id` ASC LIMIT 2";

result = mysql_query（

result = mysql_query(

query）;

echo < h2> Seria A< / h2>< hr />;

while（

query); echo "<h2>Seria A</h2><hr/>"; while(

这篇关于第一行数据库数据在一段时间后没有更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！