Update Problem

[markusschmitt]

Tag,
Hab ein update Problem, seh den Fehler aber nicht!

Fehlermeldung:
1064: You have an error in your SQL syntax near '(hostname, username, password, port, comment) = (192.168.1.100,furtwangen,ghb,21' at line 1

DB Aufbau
hostname, username, password = varchar
port = int
comment = varchar

        if(strlen($_POST['id']) == null || strlen($_POST['host']) == null || strlen($_POST['user']) == null || strlen($_POST['pass']) == null || strlen($_POST['port']) == null)
        {
            header ("Location: server.php");
        }
        else
        {
            if(strlen($_POST['comment']) == null)
            {
                echo "Hallo<br>";
                $comment = $_POST['comment'];
                $comment = "";
            }
            else
            {
                $comment = $_POST['comment'];
            }
            $hostname = addslashes($_POST['host']);
            $username = addslashes($_POST['user']);
            $password = addslashes($_POST['pass']);
            $port = addslashes($_POST['port']);
            $comment = addslashes($comment);
            $sql = "UPDATE server SET (hostname, username, password, port, comment) = ($hostname,$username,$password,$port,$comment) WHERE id = $_POST[id]";
            $update = mysql_query("$sql") or die(mysql_errno().": ".mysql_error());
        } 

Mfg Markus

[MelloPie]

Weil Deine Syntax falsch is

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]

[markusschmitt]

$sql = "UPDATE server SET hostname = $hostname, username = $username, password = $password, port = $port, comment = $comment WHERE id = $_POST[id]";

Fehlermeldung:
1064: You have an error in your SQL syntax near '.1.100, username = furtwangen, password = ghb, port = 21, comment = IP WHERE id ' at line 1

Mfg Markus

[MelloPie]

Variable in ' und das $_POST['id'] in Stringverkettung benutzen

[MelloPie]

Variable in ' und das $_POST['id'] in Stringverkettung benutzen

[markusschmitt]

OK, Danke funktioniert. Hab jetzt noch ein Problem mit einem Lösch Statement
$sql = "DELETE server WHERE id = '$id'";
1064: You have an error in your SQL syntax near 'server WHERE id = '3'' at line 1

Mfg Markus

[markusschmitt]

zurück genommen.

FROM vergessen

Mfg Markus