| Autor | Zpráva | ||
|---|---|---|---|
| jaroslav7 Profil |
#1 · Zasláno: 2. 12. 2012, 00:26:59
Zdravím,
potřebuji poradit, kde mám chybu v daném dotazu. Píše mi to: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''WHERE zakaznik_login = 'uzivatel1'' at line 1 if (isset($_POST['odeslat']) && $_POST['odeslat'] == "Upravit") {
$update = mysql_query("UPDATE zakaznik SET " .
"jmeno = '" . $_POST['jmeno'] . "', " .
"prijmeni = '" . $_POST['prijmeni'] . "', " .
"adresa = '" . $_POST['adresa'] . "', " .
"PSC = '" . $_POST['psc'] . "', " .
"email = '" . $_POST['email'] . "', " .
"mesto = '" . $_POST['mesto'] . "', " .
"stat = '" . $_POST['zeme'] . "', " .
"telefon = '" . $_POST['telefon'] . "', " .
"heslo = '" . $_POST['heslo'] . "', " .
"login = '" . $_POST['username'] . "', " .
"'WHERE login = '" . $_SESSION['prihlaseny_uzivatel'] . "'")
or die(mysql_error());
} |
||
| Sir Tom Profil |
jaroslav7:
"login = '" . $_POST['username'] . "', " . "'WHERE login = '" . $_SESSION['prihlaseny_uzivatel'] . "'" |
||
| jaroslav7 Profil |
#3 · Zasláno: 2. 12. 2012, 00:56:30
Sir Tom:
Díky moc, už to funguje. |
||
|
Časová prodleva: 11 let
|
|||
0