summaryrefslogtreecommitdiff
path: root/www-ssl/admin
diff options
context:
space:
mode:
authorcookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2006-04-17 09:34:05 +0000
committercookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2006-04-17 09:34:05 +0000
commit0006883dc9bd7d4f69e5fdb83def42cfe1382cac (patch)
tree79374655f0fdf808edea4ee53491a9863aa4be1c /www-ssl/admin
parentd4eb7def46353d3436dba55e169e22017d204bb4 (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-xwww-ssl/admin/user.php2
-rwxr-xr-xwww-ssl/admin/user2.php4
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&uuml;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 "&Auml;nderung wurde gesichert...\n";