CODEWITHSUNDEEP
phpmysql
Jente
Jente

Reputation: 632

SQL Error (update gegevens):: Unknown column '1' in 'field list'

I Know this is a 'well-known' problem, but I can't get it working. The following MySQL Query (in PHP) gives me this error

 $sqle = "UPDATE $gameID SET `$column` = `$vav` WHERE drank='$drank'";
 $resulte = mysql_query($sqle) or die('SQL Error (update gegevens):: '.mysql_error());

I tried a lot of different quotes, but I can't get it working. Can someone send me in the right direction?

also;

$column = 'prijs_max';
$vav = $INFO[$count+1];  // returning a number

The complete loop after editing

$count = 0;
    foreach ($INFO as $value) {
        $column = "";
        if(strpos($value, '§') !== false) {
            $pieces = explode('§', $value);
            $drank = $pieces[0];
            $rang = $pieces[1];

            if ($rang == 'start') {
                $column = 'prijs_start';
            } elseif ($rang == 'min') {
                $column = 'prijs_min';
            } elseif ($rang == 'max') {
                $column = 'prijs_max';
            }

            if ($column == 'prijs_start') {
                $bidmaxquery = "SELECT drank FROM $gameID WHERE drank = '$drank'";
                $bidmax = mysql_query($bidmaxquery) or die('SQL Error (get drank) :: '.mysql_error());

                if (mysql_num_rows($bidmax) == 0) {
                    $vav = $INFO[$count+1];
                    $inc = $INFO[$count+7];
                    $sqld = "INSERT INTO $gameID (drank,$column,prijs_current,increment) VALUES ('$drank','$vav','$vav','$inc')";
                    $queryd = mysql_query($sqld) or die('SQL Error (insert eerste gegevens):: '.mysql_error());
                }
            } else {
                $vav = $INFO[$count+1];
                echo $vav;
                echo "<br>";
                $sqle = "UPDATE $gameID SET `".$column."`=$vav WHERE drank='$drank'";
                $resulte = mysql_query($sqle) or die('SQL Error (update gegevens):: '.mysql_error());
            }

        }
        $count ++;
    }

Upvotes: 0

Views: 111

Answers (2)

rawdog
rawdog

Reputation: 732

"UPDATE $gameID SET $column ='$vav' WHERE drank='$drank'";

Upvotes: 0

Paul Lo
Paul Lo

Reputation: 6148

Try

"UPDATE $gameID SET `".$column."`='$vav' WHERE drank='$drank'";

Upvotes: 1

Related Questions