$MySQL_server= 'localhost'; $MySQL_user= 'root'; $MySQL_password = 'i1kmK0vFW6'; $MySQL_database = 'jessica_shoppingnews24de'; $dzA2=mysql_connect($MySQL_server,$MySQL_user,$MySQL_password); mysql_select_DB($MySQL_database,$dzA2); if ($_GET[User]=="") $_GET[User]="MRete001"; $SQL ="Select * from RVG_Struktur where (Code='".$_GET[User]."' or HWLCode='".$_GET[User]."') and Aktiv>=0"; $AT1 = mysql_query($SQL); $rowp=mysql_fetch_array($AT1); if ($rowp[Code]=="") { $SubID=53; $_GET[User]="MRete001"; } else { $SubID=$rowp[ID]; } $TSQL="Insert into RVG_Login (SUB_ID,Userkennung,Gutschein,Datum, Nachricht, Operation) values(".$SubID.",'".$_GET[User]."','PL',now(),6666,'PL_index--Ratgeber')"; mysql_query($TSQL); //echo $TSQL; die; ?>