diff options
author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-04-17 09:34:05 +0000 |
---|---|---|
committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-04-17 09:34:05 +0000 |
commit | 0006883dc9bd7d4f69e5fdb83def42cfe1382cac (patch) | |
tree | 79374655f0fdf808edea4ee53491a9863aa4be1c /www-ssl/admin | |
parent | d4eb7def46353d3436dba55e169e22017d204bb4 (diff) |
SQL syntax nicht gros geschrieben
git-svn-id: svn://svn.cccv.de/engel-system@117 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'www-ssl/admin')
-rwxr-xr-x | www-ssl/admin/user.php | 2 | ||||
-rwxr-xr-x | www-ssl/admin/user2.php | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/www-ssl/admin/user.php b/www-ssl/admin/user.php index cbe404d5..403c10ee 100755 --- a/www-ssl/admin/user.php +++ b/www-ssl/admin/user.php @@ -126,7 +126,7 @@ else if( $_GET["Type"] == "Normal" ) { - $SQL = "SELECT * FROM User where UID=". $_GET["enterUID"]; + $SQL = "SELECT * FROM User WHERE UID=". $_GET["enterUID"]; $Erg = mysql_query($SQL, $con); if (mysql_num_rows($Erg) != 1) diff --git a/www-ssl/admin/user2.php b/www-ssl/admin/user2.php index bb2dac3f..7a9467b8 100755 --- a/www-ssl/admin/user2.php +++ b/www-ssl/admin/user2.php @@ -105,7 +105,7 @@ if (IsSet($_GET["action"])) case "newpw": echo "Bitte neues Kennwort für <b>"; // Get Nick - $USQL = "SELECT * FROM User where UID=". $_GET["eUID"]; + $USQL = "SELECT * FROM User WHERE UID=". $_GET["eUID"]; $Erg = mysql_query($USQL, $con); echo mysql_result($Erg, 0, "Nick"); echo "</b> eingeben:<br>"; @@ -122,7 +122,7 @@ if (IsSet($_GET["action"])) { // beide Passwoerter passen... $_POST["ePasswort"] = PassCrypt($_POST["ePasswort"]); $SQL = "UPDATE `User` SET `Passwort`='". $_POST["ePasswort"]. "' ". - "where `UID` = '". $_POST["eUID"]. "'"; + "WHERE `UID` = '". $_POST["eUID"]. "'"; $Erg = db_query($SQL, "User new passwort"); if ($Erg == 1) { echo "Änderung wurde gesichert...\n"; |