SQL Abfrage Allgemein

<!DOCTYPE html> <html dir="ltr" lang="de"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>SQL Abfrage Allgemein - phpBB.de</title> <link rel="alternate" type="application/atom+xml" title="Feed - phpBB.de" href="/community/feed?sid=c3b939345343f9446cfa593dba84865c"> <link rel="alternate" type="application/atom+xml" title="Feed - Neuigkeiten" href="/community/feed/news?sid=c3b939345343f9446cfa593dba84865c"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/community/feed/topics?sid=c3b939345343f9446cfa593dba84865c"> <link rel="alternate" type="application/atom+xml" title="Feed - Aktive Themen" href="/community/feed/topics_active?sid=c3b939345343f9446cfa593dba84865c"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Coding & Technik" href="/community/feed/forum/6?sid=c3b939345343f9446cfa593dba84865c"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - SQL Abfrage Allgemein" href="/community/feed/topic/246443?sid=c3b939345343f9446cfa593dba84865c"> <link rel="canonical" href="https://www.phpbb.de/community/viewtopic.php?t=246443">  <link href="./assets/css/font-awesome.min.css?assets_version=280" rel="stylesheet"> <link href="./styles/prosilver/theme/stylesheet.css?assets_version=280" rel="stylesheet" /> <link href="./styles/phpBBdev1/theme/stylesheet.css?assets_version=280" rel="stylesheet"> <link href="./styles/phpBBdev1/theme/de/stylesheet.css?assets_version=280" rel="stylesheet"> <link href="./styles/phpBBdev1/theme/images/favicon/mask-icon.svg?assets_version=280" rel="mask-icon" color="#3E647B" />  <link href="./ext/phpbbde/pastebin/styles/prosilver/theme/pastebin.css?assets_version=280" rel="stylesheet" media="screen"> <link href="./ext/rmcgirr83/contactadmin/styles/prosilver/theme/imageset.css?assets_version=280" rel="stylesheet" media="screen"> </head> <body id="phpbb" class="nojs notouch section-viewtopic ltr "> <div id="wrap" class="wrap"> <a id="top" class="top-anchor" accesskey="t"></a> <div id="page-header"> <div class="headerbar" role="banner"> <div class="inner"> <div id="site-description" class="site-description"> <a id="logo" class="logo" href="./../" title="Startseite"> <span class="site_logo"></span> </a> <h1>phpBB.de</h1> <p>phpBB.de - Die deutsche phpBB-Community</p> <p class="skiplink"><a href="#start_here">Zum Inhalt</a></p> </div> <div id="search-box" class="search-box search-header" role="search"> <form action="./search.php?sid=c3b939345343f9446cfa593dba84865c" method="get" id="search"> <fieldset> <input name="keywords" id="keywords" type="search" maxlength="128" title="Suche nach Wörtern" class="inputbox search tiny" size="20" value="" placeholder="Suche…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=c3b939345343f9446cfa593dba84865c" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="sid" value="c3b939345343f9446cfa593dba84865c" /> </fieldset> </form> </div> <div id="phpbbde_navigation" class="phpbbde_navigation"> <div class="menu-button"> <a href="#" id="navi-toggle" title="Menü anzeigen">Menü</a> </div> <ul id="mainnavi" class="mainnavi"> <li class="mainnavi-title">phpBB.de - Navigation</li> <li class="navi-button but-about"> <a href="./../phpbbde/?sid=c3b939345343f9446cfa593dba84865c"><span class="subnavi-toggle"></span>Über uns</a> <ul class="subnavi"> <li><a href="./../phpbbde/chronik/?sid=c3b939345343f9446cfa593dba84865c">phpBB.de-Chronik <span>Die Geschichte von phpBB.de in Wort und Bild</span></a></li> <li><a href="./../phpbbde/team/?sid=c3b939345343f9446cfa593dba84865c">Das Team <span>Erfahre mehr über das Team hinter phpBB.de</span></a></li> <li><a href="./../phpbbde/fragen/?sid=c3b939345343f9446cfa593dba84865c">Fragen an das Team <span>Ihr habt gefragt, wir haben geantwortet</span></a></li> <li><a href="/community/contactadmin?sid=c3b939345343f9446cfa593dba84865c">Kontaktformular <span>Formular zur Kontaktaufnahme mit dem phpBB.de-Team</span></a></li> <li><a href="./../phpbbde/impressum/?sid=c3b939345343f9446cfa593dba84865c">Impressum <span>Das phpBB.de-Impressum</span></a></li> </ul> </li> <li class="navi-button but-phpbb"> <a href="./../infos/?sid=c3b939345343f9446cfa593dba84865c"><span class="subnavi-toggle"></span>phpBB</a> <ul class="subnavi"> <li><a href="./../infos/?sid=c3b939345343f9446cfa593dba84865c">Infos über phpBB <span>Erfahre mehr über phpBB</span></a></li> <li><a href="./../infos/tour/?sid=c3b939345343f9446cfa593dba84865c">Die phpBB-Tour <span>Was ist phpBB und wo bekomme ich es?</span></a></li> <li><a href="./../infos/features/?sid=c3b939345343f9446cfa593dba84865c">Feature-Vergleich <span>Lerne alle Features kennen, die dir phpBB bietet</span></a></li> <li><a href="./../infos/anpassen/?sid=c3b939345343f9446cfa593dba84865c">phpBB anpassen <span>Nutze Erweiterungen und Styles, um phpBB deinen Wünschen anzupassen</span></a></li> <li><a href="./../infos/entwickler/3.3/?sid=c3b939345343f9446cfa593dba84865c">Informationen für Entwickler <span>phpBB-Projektarchiv, nützliche Links, ...</span></a></li> <li><a href="./../xref/3.3/?sid=c3b939345343f9446cfa593dba84865c">Cross-Referenz 3.3 <span>Cross-Referenz des phpBB-Quellcodes</span></a></li> </ul> </li> <li class="navi-button but-downloads"> <a href="./../downloads/?sid=c3b939345343f9446cfa593dba84865c"><span class="subnavi-toggle"></span>Downloads</a> <ul class="subnavi"> <li><a href="./../downloads/pakete/?sid=c3b939345343f9446cfa593dba84865c">phpBB-Pakete <span>Die aktuellen dt. Komplett- und Updatepakete von phpBB</span></a></li> <li><a href="./../downloads/sprachpakete/?sid=c3b939345343f9446cfa593dba84865c">Sprachpakete <span>Die aktuellen deutschen Sprachdateien für phpBB</span></a></li> <li><a href="./../downloads/entwicklung/?sid=c3b939345343f9446cfa593dba84865c">Entwicklung <span>Entwickler-Downloads</span></a></li> </ul> </li> <li class="navi-button but-docu"> <a href="./../support/?sid=c3b939345343f9446cfa593dba84865c"><span class="subnavi-toggle"> </span>Support</a> <ul class="subnavi"> <li><a href="./../support/doku/quickstart/3.3/?sid=c3b939345343f9446cfa593dba84865c">Schnelleinstieg <span>Erklärt dir die Einrichtung deines phpBB Boards</span></a></li> <li><a href="https://www.phpbb.de/help/faq">Häufig gestellte Fragen <span>Häufige Fragen im Zusammenhang mit der Nutzung von phpBB</span></a></li> <li><a href="./../kb/index?sid=c3b939345343f9446cfa593dba84865c">Knowledge Base <span>Unsere Wissensdatenbank mit vielen und hilfreichen Artikeln</span></a></li> <li><a href="./../support/videos/?sid=c3b939345343f9446cfa593dba84865c">Videos <span>Unsere Supportvideos erklären Funktionen von phpBB</span></a></li> <li><a href="./../support/doku/?sid=c3b939345343f9446cfa593dba84865c">Dokumentation <span>Hier findest Du Dokumentationen zu phpBB</span></a></li> <li><a href="./../support/doku/perror/?sid=c3b939345343f9446cfa593dba84865c">MySQL-Fehlercodes <span>Mysql Fehlercodes dokumentiert</span></a></li> <li><a href="./../support/doku/htpasswd/?sid=c3b939345343f9446cfa593dba84865c">.htpasswd-Generator <span>Einfach zu bedienener Generator für .htpasswd Dateien</span></a></li> </ul> </li> <li class="navi-button but-community"> <a href="./../community/?sid=c3b939345343f9446cfa593dba84865c"><span class="subnavi-toggle"> </span>Community</a> <ul class="subnavi"> <li><a href="./../community/viewforum.php?f=145&sid=c3b939345343f9446cfa593dba84865c">Supportforen <span>Hilfe bei der Installation und Benutzung</span></a></li> <li><a href="./../community/viewforum.php?f=104&sid=c3b939345343f9446cfa593dba84865c">Communityforen<span>Allgemeine Diskussionen und phpBB-Usergroups</span></a></li> <li><a href="./../community/viewforum.php?f=148&sid=c3b939345343f9446cfa593dba84865c">Extension-Foren<span>Auf der Suche nach einer Extension? Fragen zu einer Extension?</span></a></li> <li><a href="./../community/viewforum.php?f=152&sid=c3b939345343f9446cfa593dba84865c">Styleforen<span>Du suchst einen neuen Style oder hast Probleme mit einem Style?</span></a></li> <li><a href="./../kb/knigge?sid=c3b939345343f9446cfa593dba84865c">Der kleine phpBB.de-Knigge <span>Eine kleine Liste von wichtigen Regeln auf phpBB.de</span></a></li> <li><a href="./../phpbbde/chat/?sid=c3b939345343f9446cfa593dba84865c">Discord / Chat <span>Besuche den Discord-Server oder den Chat auf Freenode</span></a></li> </ul> </li> </ul> </div> </div> </div> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-main" class="nav-main linklist" role="menubar"> <li id="quick-links" class="quick-links dropdown-container responsive-menu" data-skip-responsive="true"> <a href="#" class="dropdown-trigger"> <i class="icon fa-bars fa-fw" aria-hidden="true"></i><span>Schnellzugriff</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents" role="menu"> <li class="separator"></li> <li> <a href="./search.php?search_id=unanswered&sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-file-o fa-fw icon-gray" aria-hidden="true"></i><span>Unbeantwortete Themen</span> </a> </li> <li> <a href="./search.php?search_id=active_topics&sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-file-o fa-fw icon-blue" aria-hidden="true"></i><span>Aktive Themen</span> </a> </li> <li class="separator"></li> <li> <a href="./search.php?sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span>Suche</span> </a> </li> <li class="separator"></li> <li> <a href="./../phpbbde/team.php?sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="separator"></li> </ul> </div> </li> <li data-skip-responsive="true"> <a href="./../help/faq?sid=c3b939345343f9446cfa593dba84865c" rel="help" title="Häufig gestellte Fragen" role="menuitem"> <i class="icon fa-question-circle fa-fw" aria-hidden="true"></i><span>FAQ</span> </a> </li> <li data-last-responsive="true"><a href="/community/pastebin/?sid=c3b939345343f9446cfa593dba84865c" title="Pastebin"><i class="icon fa-clipboard fa-fw" aria-hidden="true"></i><span>Pastebin</span></a></li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=login&redirect=viewtopic.php%3Ft%3D246443&sid=c3b939345343f9446cfa593dba84865c" title="Anmelden" accesskey="x" role="menuitem"> <i class="icon fa-power-off fa-fw" aria-hidden="true"></i><span>Anmelden</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=register&sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-pencil-square-o fa-fw" aria-hidden="true"></i><span>Registrieren</span> </a> </li> </ul> <ul id="nav-breadcrumbs" class="nav-breadcrumbs linklist navlinks" role="menubar"> <li class="breadcrumbs" itemscope itemtype="https://schema.org/BreadcrumbList"> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./../" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span itemprop="name">Startseite</span></a><meta itemprop="position" content="1" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./index.php?sid=c3b939345343f9446cfa593dba84865c" accesskey="h" data-navbar-reference="index"><span itemprop="name">Community</span></a><meta itemprop="position" content="2" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="103"><a itemprop="item" href="./viewforum.php?f=103&sid=c3b939345343f9446cfa593dba84865c"><span itemprop="name">Entwickler-Ecke</span></a><meta itemprop="position" content="3" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="6"><a itemprop="item" href="./viewforum.php?f=6&sid=c3b939345343f9446cfa593dba84865c"><span itemprop="name">Coding & Technik</span></a><meta itemprop="position" content="4" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=c3b939345343f9446cfa593dba84865c" title="Zeigt die erweiterten Suchoptionen an" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </a> </li> </ul> </div> </div> </div> <a id="start_here" class="anchor"></a> <div id="page-body" class="page-body" role="main"> <h2 class="topic-title"><a href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c">SQL Abfrage Allgemein</a></h2>  <div style="display: none !important;">Fragen zu allen Themen rund ums Programmieren außerhalb von phpBB können hier gestellt werden - auch zu anderen Programmiersprachen oder Software wie Webservern und Editoren.<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=246443&sid=c3b939345343f9446cfa593dba84865c" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <div class="search-box" role="search"> <form method="get" id="topic-search" action="./search.php?sid=c3b939345343f9446cfa593dba84865c"> <fieldset> <input class="inputbox search tiny" type="search" name="keywords" id="search_keywords" size="20" placeholder="Thema durchsuchen…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=c3b939345343f9446cfa593dba84865c" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="t" value="246443" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="c3b939345343f9446cfa593dba84865c" /> </fieldset> </form> </div> <div class="pagination"> 12 Beiträge <ul> <li class="active"><span>1</span></li> <li><a class="button" href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&start=10" role="button">2</a></li> <li class="arrow next"><a class="button button-icon-only" href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&start=10" rel="next" role="button"><i class="icon fa-chevron-right fa-fw" aria-hidden="true"></i><span class="sr-only">Nächste</span></a></li> </ul> </div> </div> <div id="p1419851" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1419851"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=87861_1544731992.png" width="100" height="100" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=87861&sr=posts&sid=c3b939345343f9446cfa593dba84865c">3774</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.11.2007 06:20</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Euskirchen</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von chris1278"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von chris1278</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://christian-esch.de/forum/" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419851"> <h3 class="first"> <a href="./viewtopic.php?p=1419851&sid=c3b939345343f9446cfa593dba84865c#p1419851">SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419851&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419851&sid=c3b939345343f9446cfa593dba84865c#p1419851" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a></strong> » </span><time datetime="2022-11-02T21:14:03+00:00">02.11.2022 22:14</time> </p> <div class="content">Hallo also ich habe für eine Extension eine Tabelle erstellt wo ich Inhalte speichere und abrufe. Das funktioniert aus soweit gut. Bin mit meiner Extension auch soweit fertig. Es geht sich hier um eine Allgemeine Frage da ich gern einige Funktionsweisen der Extension verbessern möchte.<br> <br> Meine Tabelle sieht im Moment so aus:<br> <br> | id| wert1| wert2 usw.|<br> |:------:|:------:|:------:|<br> | x | x | x |<br> <br> Dies ist natürlich nur bildlich dargestellt.<br> <br> Es geht mir um folgendes. <br> <br> Meine Extension erhöht den Wert der Spalte [*]id immer um einen wenn man einen neuen Eintrag anlegt aber da liegt eigentlich das Problem wenn man eine Zeile mittendrin löscht stimmt die abfrage für die neu angelegten IDs nicht mehr und es knallt bei gleicher id. <br> <br> Meine Überlegung ist es eine abfrage zu generieren die die IDs nach einander auflistet und dann dem kleinsten gefunden wert stoppt dort den wert 1 addiert und dies als neue id einträgt. <br> <br> Nur leider weis ich nicht so recht wo ich da ansetzen muss. ich kann zwar mit count im sql die einträge zählen würde mein Problem aber nicht lösen.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419852" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1419852"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=206428_1703642850.png" width="90" height="90" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=206428&sr=posts&sid=c3b939345343f9446cfa593dba84865c">662</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 25.11.2018 20:32</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Lüneburg</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von IMC"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von IMC</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.indianclub.de" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419852"> <h3 > <a href="./viewtopic.php?p=1419852&sid=c3b939345343f9446cfa593dba84865c#p1419852">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419852&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419852&sid=c3b939345343f9446cfa593dba84865c#p1419852" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a></strong> » </span><time datetime="2022-11-02T21:29:27+00:00">02.11.2022 22:29</time> </p> <div class="content">Ich kenne das so dass man den Job mit den ID's der Datenbank überlässt.<br> <a href="https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html" class="postlink">https://dev.mysql.com/doc/refman/8.0/en ... ement.html</a><br> <a href="https://www.w3schools.com/sql/sql_autoincrement.asp" class="postlink">https://www.w3schools.com/sql/sql_autoincrement.asp</a><br> <br> Dadurch ist es nicht möglich das eine ID identisch vergeben wird.</div> <div id="sig1419852" class="signature">Gruß, Thorsten</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419853" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1419853"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=87861_1544731992.png" width="100" height="100" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=87861&sr=posts&sid=c3b939345343f9446cfa593dba84865c">3774</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.11.2007 06:20</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Euskirchen</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von chris1278"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von chris1278</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://christian-esch.de/forum/" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419853"> <h3 > <a href="./viewtopic.php?p=1419853&sid=c3b939345343f9446cfa593dba84865c#p1419853">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419853&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419853&sid=c3b939345343f9446cfa593dba84865c#p1419853" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a></strong> » </span><time datetime="2022-11-02T21:55:00+00:00">02.11.2022 22:55</time> </p> <div class="content">Ja das hab ich auch als notlösung. Damit hat das "knallen" aufgehört. <br> <br> Alsomal zur verdeutlichumg hier meine tabellen:<br> <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>return [ 'add_tables' => [ $this->table_prefix . 'chris1278_social' => [ 'COLUMNS' => [ 'var_social_index' => ['UINT', null, 'auto_increment'], 'var_social_box_nr' => ['VCHAR:255' , ''], 'var_social_icon_url' => ['VCHAR:255' , ''], 'var_social_ficon_url' => ['VCHAR:255' , ''], 'var_social_url' => ['VCHAR:255' , ''], 'var_social_url_enable' => ['VCHAR:255' , ''], 'var_social_name' => ['VCHAR:255' , ''], ], 'PRIMARY_KEY' => [ 'var_social_index', ], ], ], ];</code></pre></div> Ursprünglich war das feld var_social_box_nr der primär key. So nummeriert er die zeilen forlaufend und ich kann die box_nr frei verwenden. <br> <br> Das eigentlich ziel ist folgendes:<br> <br> Es wurde sagen wir 10 einträge generiert mit den var_social_box_nr Nummern 1 bis 10 <br> <br> Also etwa so:<br> <br> 1...<br> 2...<br> 3...<br> 4...<br> 5...<br> 6...<br> 7...<br> 8...<br> 9...<br> 10...<br> <br> <br> Jetzt wird sagen wir mal Box nummer 5 gelöscht. Jetzt soll beim neu anleged wieder die freigewordende Nummer 5 verwendet werden. Ich Würde gern wissen wie ich eine abfrage gestalten kann womit ich diese frei nummer rausfiltern kann und diese in ein array einfüge was ich weiter verwenden kann. Beispiel so.<br> <br> <br> Prüfe 0 -> ist da = weiter<br> Prüfe 1 -> ist da = weiter<br> Prüfe 2 -> ist da = weiter<br> Prüfe 3-> ist da = weiter<br> Prüfe 4 -> ist da = weiter<br> Prüfe 5 -> ist da = array [] = '5'; Weiter zur nächsten aufgabe.<br> <br> So in etwa.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419854" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1419854"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=206428_1703642850.png" width="90" height="90" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=206428&sr=posts&sid=c3b939345343f9446cfa593dba84865c">662</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 25.11.2018 20:32</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Lüneburg</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von IMC"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von IMC</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.indianclub.de" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419854"> <h3 > <a href="./viewtopic.php?p=1419854&sid=c3b939345343f9446cfa593dba84865c#p1419854">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419854&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419854&sid=c3b939345343f9446cfa593dba84865c#p1419854" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a></strong> » </span><time datetime="2022-11-02T22:22:36+00:00">02.11.2022 23:22</time> </p> <div class="content">Dann ist vielleicht dies deine Lösung.<br> <a href="https://www.gutefrage.net/frage/freie-nummer-in-sql-datenbank-finden#answer-11280257" class="postlink">https://www.gutefrage.net/frage/freie-n ... r-11280257</a></div> <div id="sig1419854" class="signature">Gruß, Thorsten</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419855" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1419855"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=87861_1544731992.png" width="100" height="100" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=87861&sr=posts&sid=c3b939345343f9446cfa593dba84865c">3774</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.11.2007 06:20</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Euskirchen</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von chris1278"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von chris1278</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://christian-esch.de/forum/" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419855"> <h3 > <a href="./viewtopic.php?p=1419855&sid=c3b939345343f9446cfa593dba84865c#p1419855">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419855&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419855&sid=c3b939345343f9446cfa593dba84865c#p1419855" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a></strong> » </span><time datetime="2022-11-03T07:11:37+00:00">03.11.2022 08:11</time> </p> <div class="content">Ok ich denke damit kann ich was anfangen. Das heißt wenn ich das richtig verstehe um bei meinem Beispiel zu bleiben, würde er wenn ich das mit der select min variante aufrufe bei gelöschter id 5 dann hochzählen und als Ergebnis die 4 ausspucken. wenn das so ist denk ich das ich damit was anfangen kann. werde das testen. Ich danke dir für den Hinweis.<br> <br> @edit<br> <br> Ok ich hab das getestet aber bringt nichts. das würde den kleinsten vorhandenen wert anzeigen. Und löst mein Problem leider nicht.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419858" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1419858"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=206428_1703642850.png" width="90" height="90" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=206428&sr=posts&sid=c3b939345343f9446cfa593dba84865c">662</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 25.11.2018 20:32</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Lüneburg</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von IMC"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von IMC</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.indianclub.de" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419858"> <h3 > <a href="./viewtopic.php?p=1419858&sid=c3b939345343f9446cfa593dba84865c#p1419858">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419858&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419858&sid=c3b939345343f9446cfa593dba84865c#p1419858" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a></strong> » </span><time datetime="2022-11-03T15:50:28+00:00">03.11.2022 16:50</time> </p> <div class="content">Ich habe es bei mir jetzt auch mal getestet.<br> <br> Hier meine Datenbankabfrage: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>// Verbindung mit der Datenbank aufbauen $mysqli_link = mysqli_connect($dbhost, $dbuser, $dbpasswd, $dbname); // select min(nummer + 1) from tabelle where nummer + 1 not in (select nummer from tabelle) $query_string = 'SELECT MIN(id + 1) FROM newsl_empfaenger WHERE id + 1 NOT IN (SELECT id FROM newsl_empfaenger)'; $result = mysqli_query($mysqli_link, $query_string); var_dump(mysqli_fetch_array($result, MYSQLI_ASSOC)); </code></pre></div> Hier die Ausgabe:<br> <code class="inline">array(1) { ["min(id + 1)"]=> string(2) "15" } </code><br> <br> Die ID 15 ist bei mir die erste freie ID. Also funktioniert die Datenbankabfrage.<br> <br> Edit:<br> Wahrscheinlich wird die Abfrage nicht erkennen wenn die ID 1 frei ist. Das solltest du einmal testen und dann gegebenenfalls dies in deinem Code mit einer extra Abfrage prüfen lassen.</div> <div id="sig1419858" class="signature">Gruß, Thorsten</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419859" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1419859"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=8739&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=8739_1704634026.png" width="52" height="80" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=8739&sid=c3b939345343f9446cfa593dba84865c" style="color: #58A504;" class="username-coloured">Dr.Death</a> </dt> <dd class="profile-rank">Moderator<br /><img src="./images/ranks/rang_moderator.png" alt="Moderator" title="Moderator" /></dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=8739&sr=posts&sid=c3b939345343f9446cfa593dba84865c">17452</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 23.04.2003 08:22</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Xanten</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von Dr.Death"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von Dr.Death</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="http://www.lpi-clan.de" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419859"> <h3 > <a href="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419859&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=8739&sid=c3b939345343f9446cfa593dba84865c" style="color: #58A504;" class="username-coloured">Dr.Death</a></strong> » </span><time datetime="2022-11-03T18:48:17+00:00">03.11.2022 19:48</time> </p> <div class="content">Kleiner Tip:<br> IDs mit auto increments sollte man nicht neu benutzen wenn eine ID gelöscht wurde.<br> <br> Das Vergeben von auto increment Werten überlässt man der Datenbank.<br> Ansonsten kann es ganz schnell passieren, das der SQL Code zwar auf xxx funktioniert aber auf yyy oder zzz nicht. (Tausche xxx,yyy und zzz wahllos gegen MySQL, PostgreSQL, Oracle....)<br> <br> Ich hatte auch mal in meiner Extensions feste IDs zu Einträgen zugewiesen:<br> <br> <code class="inline">$sql_ary[] = ['team_id' => 1, 'team_name' => 'Mercedes F1 Team', 'team_img' => '', 'team_car' => '',];</code><br> <br> Ich wollte, das die ID 1 das Team "Mercedes" ist.... das klappte soweit, bis ich anstelle einer MySQL/MariaDB eine PostgreSQL DB benutzt habe.<br> Da musste ich dann anschliessend die Autoincrements (Sequence Numbers) von Hand nachjustieren..... macht also mehr Arbeit bei jeder ID Anpassung.<br> <br> Am besten also Einträge in die Tabelle ohne Angabe der ID vornehmen lassen....das können die Datenbank selbst regeln.<br> <br> <a href="https://github.com/DrDeath/phpbb-ext-f1webtip/commit/3494c743de1944fd979ac06ba1180c0646b4d836" class="postlink">https://github.com/DrDeath/phpbb-ext-f1 ... 0646b4d836</a></div> <div id="sig1419859" class="signature">Doc.<br> <br> <a href="https://www.phpbb.de/kb/knigge" class="postlink">Der kleine phpBB.de-Knigge - unsere Hausordnung</a></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419861" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1419861"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=87861_1544731992.png" width="100" height="100" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=87861&sr=posts&sid=c3b939345343f9446cfa593dba84865c">3774</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.11.2007 06:20</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Euskirchen</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von chris1278"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von chris1278</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://christian-esch.de/forum/" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419861"> <h3 > <a href="./viewtopic.php?p=1419861&sid=c3b939345343f9446cfa593dba84865c#p1419861">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419861&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419861&sid=c3b939345343f9446cfa593dba84865c#p1419861" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a></strong> » </span><time datetime="2022-11-03T19:41:32+00:00">03.11.2022 20:41</time> </p> <div class="content"><blockquote cite="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859"><div><cite><a href="./memberlist.php?mode=viewprofile&u=8739&sid=c3b939345343f9446cfa593dba84865c">Dr.Death</a> hat geschrieben: <a href="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859" aria-label="Zitierten Beitrag anzeigen" data-post-id="1419859" onclick="if(document.getElementById(hash.substr(1)))href=hash"><i class="icon fa-arrow-circle-up fa-fw" aria-hidden="true"></i></a><span class="responsive-hide">03.11.2022 19:48</span></cite> Kleiner Tip:<br> IDs mit auto increments sollte man nicht neu benutzen wenn eine ID gelöscht wurde. </div></blockquote> Nein darum nutze ich dafür eine separate id vergabe mit eigener spalte.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419862" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1419862"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=206428_1703642850.png" width="90" height="90" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=206428&sr=posts&sid=c3b939345343f9446cfa593dba84865c">662</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 25.11.2018 20:32</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Lüneburg</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von IMC"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von IMC</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://www.indianclub.de" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419862"> <h3 > <a href="./viewtopic.php?p=1419862&sid=c3b939345343f9446cfa593dba84865c#p1419862">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419862&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419862&sid=c3b939345343f9446cfa593dba84865c#p1419862" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c" class="username">IMC</a></strong> » </span><time datetime="2022-11-03T21:23:16+00:00">03.11.2022 22:23</time> </p> <div class="content"><blockquote cite="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859"><div><cite><a href="./memberlist.php?mode=viewprofile&u=8739&sid=c3b939345343f9446cfa593dba84865c">Dr.Death</a> hat geschrieben: <a href="./viewtopic.php?p=1419859&sid=c3b939345343f9446cfa593dba84865c#p1419859" aria-label="Zitierten Beitrag anzeigen" data-post-id="1419859" onclick="if(document.getElementById(hash.substr(1)))href=hash"><i class="icon fa-arrow-circle-up fa-fw" aria-hidden="true"></i></a><span class="responsive-hide">03.11.2022 19:48</span></cite> Das Vergeben von auto increment Werten überlässt man der Datenbank. </div></blockquote> Dem kann ich nur zustimmen. Dies ist um so wichtiger wenn es Möglich ist dass gleichzeitige Zugriffe stattfinden können.<br> Bei der "Handvergabe" von ID's könnten dann Dopplungen entstehen.</div> <div id="sig1419862" class="signature">Gruß, Thorsten</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p1419863" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1419863"> <dt class="has-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="avatar"><img class="avatar" src="./download/file.php?avatar=87861_1544731992.png" width="100" height="100" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a> </dt> <dd class="profile-rank">Mitglied</dd> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=87861&sr=posts&sid=c3b939345343f9446cfa593dba84865c">3774</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 12.11.2007 06:20</dd> <dd class="profile-custom-field profile-phpbb_location"><strong>Wohnort:</strong> Euskirchen</dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von chris1278"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von chris1278</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="https://christian-esch.de/forum/" title="Website" class="last-cell"> <span class="contact-icon phpbb_website-icon">Website</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content1419863"> <h3 > <a href="./viewtopic.php?p=1419863&sid=c3b939345343f9446cfa593dba84865c#p1419863">Re: SQL Abfrage Allgemein</a> </h3> <ul class="post-buttons"> <li> <a href="./posting.php?mode=quote&p=1419863&sid=c3b939345343f9446cfa593dba84865c" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author"> <a class="unread" href="./viewtopic.php?p=1419863&sid=c3b939345343f9446cfa593dba84865c#p1419863" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=87861&sid=c3b939345343f9446cfa593dba84865c" class="username">chris1278</a></strong> » </span><time datetime="2022-11-03T21:57:39+00:00">03.11.2022 22:57</time> </p> <div class="content"><blockquote cite="./viewtopic.php?p=1419862&sid=c3b939345343f9446cfa593dba84865c#p1419862"><div><cite><a href="./memberlist.php?mode=viewprofile&u=206428&sid=c3b939345343f9446cfa593dba84865c">IMC</a> hat geschrieben: <a href="./viewtopic.php?p=1419862&sid=c3b939345343f9446cfa593dba84865c#p1419862" aria-label="Zitierten Beitrag anzeigen" data-post-id="1419862" onclick="if(document.getElementById(hash.substr(1)))href=hash"><i class="icon fa-arrow-circle-up fa-fw" aria-hidden="true"></i></a><span class="responsive-hide">03.11.2022 22:23</span></cite> Dies ist um so wichtiger wenn es Möglich ist dass gleichzeitige Zugriffe stattfinden können.<br> Bei der "Handvergabe" von ID's könnten dann Dopplungen entstehen. </div></blockquote> <br> Das ist ja das was ich bei meinem test rausgefunden habe. drum habe ich zwecks dieses problem ja eine spalte die mittels auto increment als index funktioniert. Diese tue ich weder auslesen noch bearbeiten. <br> <br> So sieht das aus:<br> <a href="https://prnt.sc/StjwtokN84iL" class="postlink">https://prnt.sc/StjwtokN84iL</a><br> <br> bzw.<br> <br> <a href="https://prnt.sc/4c20rmfawOu9" class="postlink">https://prnt.sc/4c20rmfawOu9</a><br> <br> wobei die spalte var_social_index die auto increment funktion hat. Diese Spalte wird auch nicht bei mir im php Code ausgelesen oder sonstwas. <br> <br> Ich spreche zue auswahl bearbeiten und löschen nur die werte in der var_social_box_nr an. Dementsprechend löscht er entweder den eintrag mit der entsprechenden nummer oder er ruft zum bearbeiten die daten der zeile (ohne var_social_index) ab und speichert diese dann.</div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div class="action-bar bar-bottom"> <a href="./posting.php?mode=reply&t=246443&sid=c3b939345343f9446cfa593dba84865c" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <form method="post" action="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c"> <div class="dropdown-container dropdown-container-left dropdown-button-control sort-tools"> <span title="Anzeige- und Sortierungs-Einstellungen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-sort-amount-asc fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown hidden"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents"> <fieldset class="display-options"> <label>Anzeigen: <select name="st" id="st"><option value="0" selected="selected">Alle Beiträge</option><option value="1">1 Tag</option><option value="7">7 Tage</option><option value="14">2 Wochen</option><option value="30">1 Monat</option><option value="90">3 Monate</option><option value="180">6 Monate</option><option value="365">1 Jahr</option></select></label> <label>Sortiere nach: <select name="sk" id="sk"><option value="a">Autor</option><option value="t" selected="selected">Erstellungsdatum</option><option value="s">Betreff</option></select></label> <label>Richtung: <select name="sd" id="sd"><option value="a" selected="selected">Aufsteigend</option><option value="d">Absteigend</option></select></label> <hr class="dashed" /> <input type="submit" class="button2" name="sort" value="Los" /> </fieldset> </div> </div> </div> </form> <div class="pagination"> 12 Beiträge <ul> <li class="active"><span>1</span></li> <li><a class="button" href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&start=10" role="button">2</a></li> <li class="arrow next"><a class="button button-icon-only" href="./viewtopic.php?t=246443&sid=c3b939345343f9446cfa593dba84865c&start=10" rel="next" role="button"><i class="icon fa-chevron-right fa-fw" aria-hidden="true"></i><span class="sr-only">Nächste</span></a></li> </ul> </div> </div> <div class="action-bar actions-jump"> <p class="jumpbox-return"> <a href="./viewforum.php?f=6&sid=c3b939345343f9446cfa593dba84865c" class="left-box arrow-left" accesskey="r"> <i class="icon fa-angle-left fa-fw icon-black" aria-hidden="true"></i><span>Zurück zu „Coding & Technik“</span> </a> </p> <div class="jumpbox dropdown-container dropdown-container-right dropdown-up dropdown-left dropdown-button-control" id="jumpbox"> <span title="Gehe zu" class="button button-secondary dropdown-trigger dropdown-select"> <span>Gehe zu</span> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li><a href="./viewforum.php?f=96&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-cat-link"> <span> Wichtige Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=9&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Ankündigungen und Neuigkeiten</span></a></li> <li><a href="./viewforum.php?f=164&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Der kleine phpBB.de-Knigge - unsere Hausordnung</span></a></li> <li><a href="./viewforum.php?f=144&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-cat-link"> <span> phpBB 3.3.x</span></a></li> <li><a href="./viewforum.php?f=145&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Support-Forum</span></a></li> <li><a href="./viewforum.php?f=148&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Extension-Foren</span></a></li> <li><a href="./viewforum.php?f=150&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Extension Support</span></a></li> <li><a href="./viewforum.php?f=151&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Extension Suche/Anfrage</span></a></li> <li><a href="./viewforum.php?f=149&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Extensions in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=140&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Extension Bastelstube</span></a></li> <li><a href="./viewforum.php?f=163&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   ABD Extensions</span></a></li> <li><a href="./viewforum.php?f=152&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Style-Foren</span></a></li> <li><a href="./viewforum.php?f=153&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=154&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Styles in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=141&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Übersetzungs-Foren</span></a></li> <li><a href="./viewforum.php?f=161&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.3.x] Übersetzungs-Diskussionen</span></a></li> <li><a href="./viewforum.php?f=157&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.2.x] Übersetzungs-Diskussionen</span></a></li> <li><a href="./viewforum.php?f=156&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Extension-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=143&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   Übersetzungs-Diskussionen (abgeschlossen)</span></a></li> <li><a href="./viewforum.php?f=103&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-cat-link"> <span> Entwickler-Ecke</span></a></li> <li><a href="./viewforum.php?f=6&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Coding & Technik</span></a></li> <li><a href="./viewforum.php?f=158&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Area51 auf phpBB.com</span></a></li> <li><a href="./viewforum.php?f=100&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-cat-link"> <span> Frühere Versionen</span></a></li> <li><a href="./viewforum.php?f=155&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Foren für phpBB 3.0</span></a></li> <li><a href="./viewforum.php?f=97&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Support-Foren</span></a></li> <li><a href="./viewforum.php?f=73&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Installation, Update und Konvertierung</span></a></li> <li><a href="./viewforum.php?f=74&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Administration, Benutzung und Betrieb</span></a></li> <li><a href="./viewforum.php?f=98&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mod-Foren</span></a></li> <li><a href="./viewforum.php?f=85&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Snippets</span></a></li> <li><a href="./viewforum.php?f=87&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mod Suche/Anfragen</span></a></li> <li><a href="./viewforum.php?f=86&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mod Support</span></a></li> <li><a href="./viewforum.php?f=88&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mods in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=93&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mod Bastelstube</span></a></li> <li><a href="./viewforum.php?f=99&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Style-Foren</span></a></li> <li><a href="./viewforum.php?f=89&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=129&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Styles in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=136&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Übersetzungs-Foren</span></a></li> <li><a href="./viewforum.php?f=137&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] phpBB.de-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=134&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   [3.0.x] Mod-Übersetzungen</span></a></li> <li><a href="./viewforum.php?f=135&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Foren für phpBB 2.0</span></a></li> <li><a href="./viewforum.php?f=12&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Installation und Update</span></a></li> <li><a href="./viewforum.php?f=13&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Administration, Benutzung und Betrieb</span></a></li> <li><a href="./viewforum.php?f=101&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0 Mods</span></a></li> <li><a href="./viewforum.php?f=37&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Mod-Datenbank</span></a></li> <li><a href="./viewforum.php?f=34&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Snippets</span></a></li> <li><a href="./viewforum.php?f=47&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Mod Suche/Anfragen</span></a></li> <li><a href="./viewforum.php?f=49&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Mod Support</span></a></li> <li><a href="./viewforum.php?f=48&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Mods in Entwicklung</span></a></li> <li><a href="./viewforum.php?f=102&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0 Styles</span></a></li> <li><a href="./viewforum.php?f=42&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Styles-Datenbank</span></a></li> <li><a href="./viewforum.php?f=35&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Styles, Templates und Grafiken</span></a></li> <li><a href="./viewforum.php?f=94&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB 2.0: Mod-Bastelstube</span></a></li> <li><a href="./viewforum.php?f=104&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-cat-link"> <span> Community-Foren</span></a></li> <li><a href="./viewforum.php?f=19&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Community Talk</span></a></li> <li><a href="./viewforum.php?f=33&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   phpBB Diskussion</span></a></li> <li><a href="./viewforum.php?f=67&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Show-Off</span></a></li> <li><a href="./viewforum.php?f=105&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   phpBB Regional</span></a></li> <li><a href="./viewforum.php?f=77&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in Norddeutschland</span></a></li> <li><a href="./viewforum.php?f=78&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in Ostdeutschland</span></a></li> <li><a href="./viewforum.php?f=79&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in Süddeutschland</span></a></li> <li><a href="./viewforum.php?f=80&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in Westdeutschland</span></a></li> <li><a href="./viewforum.php?f=81&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in Österreich</span></a></li> <li><a href="./viewforum.php?f=82&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB in der Schweiz und Liechtenstein</span></a></li> <li><a href="./viewforum.php?f=83&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span><span class="spacer"></span> <span>↳   phpBB im sonstigen Ausland</span></a></li> <li><a href="./viewforum.php?f=72&sid=c3b939345343f9446cfa593dba84865c" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Newsletter-Archiv</span></a></li> </ul> </div> </div> </div> </div> <div id="page-footer" class="page-footer" role="contentinfo"> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-footer" class="nav-footer linklist" role="menubar"> <li class="breadcrumbs"> <span class="crumb"><a href="./../" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span>Startseite</span></a></span> <span class="crumb"><a href="./index.php?sid=c3b939345343f9446cfa593dba84865c" data-navbar-reference="index"><span>Community</span></a></span> </li> <li class="rightside">Alle Zeiten sind <span title="Europa/Berlin">UTC+01:00</span></li> <li class="rightside"> <a href="/community/user/delete_cookies?sid=c3b939345343f9446cfa593dba84865c" data-ajax="true" data-refresh="true" role="menuitem"> <i class="icon fa-trash fa-fw" aria-hidden="true"></i><span>Alle Cookies löschen</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./../phpbbde/impressum/?sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-info-circle fa-fw" aria-hidden="true"></i><span>Impressum </span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./../phpbbde/team/?sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="/community/contactadmin?sid=c3b939345343f9446cfa593dba84865c" role="menuitem"> <i class="icon fa-envelope fa-fw" aria-hidden="true"></i><span>Kontakt</span> </a> </li> </ul> </div> </div> <div class="copyright"> <p class="footer-row"> <span class="footer-copyright">Powered by <a href="https://www.phpbb.com/">phpBB</a>® Forum Software © phpBB Limited</span> </p> <p class="footer-row"> <span class="footer-copyright">Deutsche Übersetzung durch <a href="https://www.phpbb.de/">phpBB.de</a></span> </p> <p class="footer-row" role="menu"> <a class="footer-link" href="./ucp.php?mode=privacy&sid=c3b939345343f9446cfa593dba84865c" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=c3b939345343f9446cfa593dba84865c" title="Nutzungsbedingungen" role="menuitem"> <span class="footer-link-text">Nutzungsbedingungen</span> </a> </p> <div class="sponsor-logo"> <a href="https://linevast.de/" rel="nofollow">hosted by Linevast.de <br> <img src="./styles/phpBBdev1/theme/images/linevast.png" alt="Linevast.de" height="63" width="257"> </a> </div> </div> <div id="darkenwrapper" class="darkenwrapper" data-ajax-error-title="AJAX-Fehler" data-ajax-error-text="Bei der Verarbeitung deiner Anfrage ist ein Fehler aufgetreten." data-ajax-error-text-abort="Der Benutzer hat die Anfrage abgebrochen." data-ajax-error-text-timeout="Bei deiner Anfrage ist eine Zeitüberschreitung aufgetreten. Bitte versuche es erneut." data-ajax-error-text-parsererror="Bei deiner Anfrage ist etwas falsch gelaufen und der Server hat eine ungültige Antwort zurückgegeben."> <div id="darken" class="darken"> </div> </div> <div id="phpbb_alert" class="phpbb_alert" data-l-err="Fehler" data-l-timeout-processing-req="Bei der Anfrage ist eine Zeitüberschreitung aufgetreten."> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <h3 class="alert_title"> </h3><p class="alert_text"></p> </div> <div id="phpbb_confirm" class="phpbb_alert"> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <div class="alert_text"></div> </div> </div> </div> <div> <a id="bottom" class="anchor" accesskey="z"></a> </div> <script src="./assets/javascript/jquery-3.7.1.min.js?assets_version=280"></script> <script src="./assets/javascript/core.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/forum_fn.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/ajax.js?assets_version=280"></script> <script src="./styles/phpBBdev1/template/phpbbde_navi.js?assets_version=280"></script> <script>(function(a){if(a.getElementsByTagName("pre").length){var c=a.getElementsByTagName("head")[0],b=a.createElement("script");a=a.createElement("link");b.type="text/javascript";b.onload=function(){hljs.initHighlighting()};b.async=!0;b.src="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.12.0/highlight.min.js";c.appendChild(b);a.type="text/css";a.rel="stylesheet";a.href="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.12.0/styles/github-gist.min.css";c.appendChild(a)}})(document)</script> </body> </html>

CINXE.COM

SQL Abfrage Allgemein - phpBB.de