Gästebuch Anzahl Einträge wird nicht aktualisiert

revils · 22. Mai 2011

Moin Leute,

folgendes Problem. Die Anzahl meiner Gästebucheinträge steht bei 11, obwohl es mehr sind. Woran kanns liegen?

Gästebuch.php

PHP

<span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /><br />            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            $db_link </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">@</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_BENUTZER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">            if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_link </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">            </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// E-Mail mit dem Problem zukommen gelassen werden<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// die Fehlermeldung für den Programmierer sollte<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// das Problem ausgeben mit: mysql_error()<br /></span><span class="syntaxdefault">                die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'No connection this time - try later'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_DATENBANK </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">            or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">            $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault">  </span><span class="syntaxstring">"<br />                    SELECT *<br />                    FROM gaestebuch<br />                    WHERE aktiviert='1'<br />                    ORDER BY datum DESC LIMIT 10 "</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">            $db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<br /></span><span class="syntaxdefault">            $anzahl_eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">)+</span><span class="syntaxdefault">1</span><span class="syntaxkeyword">;</span><span class="syntaxdefault">                                  </span><span class="syntaxcomment">//Hier wird die Anzahl berechnet<br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">            while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    </span><span class="syntaxcomment">// Ausgabe der Daten<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Message: <br /><br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">            $result </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            $count </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$result</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">></span><span class="syntaxdefault"> 10</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">'<a href="gaestebuch-alt.php">---Go to older posts---</a>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">        ?><br /></span></span>

Ich habe aber noch eine Gästebuchseite mit älteren Beiträgen

PHP

<span class="syntaxhtml"><br /> <span class="syntaxdefault"><?php<br /><br />            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            $db_link </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">@</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_BENUTZER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">            if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_link </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">            </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// E-Mail mit dem Problem zukommen gelassen werden<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// die Fehlermeldung für den Programmierer sollte<br /></span><span class="syntaxdefault">                </span><span class="syntaxcomment">// das Problem ausgeben mit: mysql_error()<br /></span><span class="syntaxdefault">                die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'No connection this time - try later'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_DATENBANK </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">            or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">            $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault">  </span><span class="syntaxstring">"<br />                    SELECT  *<br />                    FROM gaestebuch<br />                    WHERE aktiviert='1'<br />                    ORDER BY datum DESC LIMIT 10 OFFSET 10"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">            $db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">            while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    </span><span class="syntaxcomment">// Ausgabe der Daten<br /><br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"Message: <br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">        ?><br /></span></span>

Sarkkan · 22. Mai 2011

Vielleicht an dem LIMIT 10 in deiner MySql-Query? .__.

revils · 22. Mai 2011

Das Problem ist, wenn ich das LIMIT 10 weg mache, werden alle Einträge auf einer Seite angezeigt, dass will ich nicht.
Ich will das max. 10 EInträge angezeigt werden und der Rest auf einer 2. Seite...sieht man ja.

Sarkkan · 22. Mai 2011

"Rest" bedeutet ALLES was nach den 10 vorherigen kam?
Dann mach das LIMIT 10 bei deinen älteren weg?

Oder stehe ich gerade nur blöd aufm Schlauch? xDD

revils · 22. Mai 2011

Genau, alles was vor den letzten 10 war soll auf die nächste Seite

Das mit dem LIMIT 10 bei meinen älteren, führt zu einem Syntac Error

Ungültige Abfrage: 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 'OFFSET 10' at line 4

Sarkkan · 22. Mai 2011

Könte ich den vllt mal deine Query sehen?

CyberGirl · 22. Mai 2011

Hi,

das Limit kannst Du ruhig drinlassen. Zum Zählen nimmst Du einfach einen anderen Query.

SQL

SELECT * FROM Tabellennamen

, gibst die Anzahl der Einträge aus und danach
kommt dann der Query zum Ausgeben dran.

LG

Sarkkan · 22. Mai 2011

wollte er nicht bei den Älteren ALLE ausgeben? Oder hab ich da echt son Verständnisproblem heute?^^

CyberGirl · 22. Mai 2011

Sarkkan,

soviel ich es verstehe wird die Anzahl der Einträge nur bei den neuen Einträgen ausgegeben.
Bei den älteren Einträgen werden nur die Einträge ab dem 11ten ausgegeben.

LG

revils · 22. Mai 2011

Richtig, die Anzahl wird nur auf der Seite angegeben, auf der die neuesten Einträge sind

<a class="postlink" href="http://www.riensartwork.de/gaestebuch.php">http://www.riensartwork.de/gaestebuch.php</a>

CyberGirl · 22. Mai 2011

Hast Du es hingekriegt mit der Anzahl der Einträgen?

revils · 22. Mai 2011

Nein leider nicht. Noch nicht

PHP

<span class="syntaxdefault"><br />            </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br />            </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">=  </span><span class="syntaxstring">"<br />                    SELECT *<br />                    FROM gaestebuch<br />                    WHERE aktiviert='1'<br />                    ORDER BY datum DESC LIMIT 10"</span><span class="syntaxkeyword">;<br /><br />            </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br />            </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">);<br />            if ( ! </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">)<br />                {<br />                    die(</span><span class="syntaxstring">'Ungültige Abfrage: ' </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">mysql_error</span><span class="syntaxkeyword">());<br />                }<br /><br />            </span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<br />            </span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br />            echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /> </span><span class="syntaxdefault"></span>

CyberGirl · 22. Mai 2011

Hi,

um die Anzahl aller Einträge zu ermitteln kann Du folgende Abfrage nutzen.

Code

$qryAlleEintraege = "SELECT * FROM gaestebuch";
 $anzahl_eintraege = mysql_num_rows($db_erg);
 echo "<p>Number of guestbook entries: $anzahl_eintraege </p>";

Um die ersten 10 Einträge auszuwählen and anzuzeigen nimmst Du wie bisher die alte Abfrage.

Code

"SELECT * FROM gaestebuch  WHERE aktiviert='1'  ORDER BY datum DESC LIMIT 10";

Schau mal ob es so geht.

LG

revils · 22. Mai 2011

Sieht jetzt so aus

PHP

<span class="syntaxdefault"><br /> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">            $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault">  </span><span class="syntaxstring">"<br />                    SELECT *<br />                    FROM gaestebuch<br />                    WHERE aktiviert='1'<br />                    ORDER BY datum DESC LIMIT 10"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">            $qryAlleEintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">            $db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $qryAlleEintraege </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">                    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">                </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<br /></span><span class="syntaxdefault">            $anzahl_eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span>

Nur zeigt er mir jetzt alle Einträge wieder an und die auch nicht nach Datum!

Anziegen der Einträge

PHP

<span class="syntaxdefault"><br /></span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<br />            </span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br />            echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />            while (</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">))<br />                {<br />                    </span><span class="syntaxcomment">// Ausgabe der Daten<br />                    </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br />                    echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br />                    echo </span><span class="syntaxstring">"Message: <br /><br />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />                }<br /><br />            </span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">);<br /><br />            </span><span class="syntaxdefault">$result </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">);<br />            </span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$result</span><span class="syntaxkeyword">);<br />            if(</span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">> </span><span class="syntaxdefault">10</span><span class="syntaxkeyword">)<br />                {<br />                    echo </span><span class="syntaxstring">'<a href="gaestebuch-alt.php">---Go to older posts---</a>'</span><span class="syntaxkeyword">;<br />                }<br /> </span><span class="syntaxdefault"></span>

CyberGirl · 23. Mai 2011

Hi,

bevor Du die Daten ausgibst mußt Du erst eine neue Abfrage starten.

Code

$qryNewEntries = "SELECT * FROM gaestebuch  WHERE aktiviert='1'  ORDER BY datum DESC LIMIT 10";
$result = mysql_query($qryNewEntries);
// Einträge hier ausgeben

So müsste es eigentlich gehen.

LG

revils · 23. Mai 2011

Ich checks nicht...

PHP

<span class="syntaxdefault"><br />$qryAlleEintraege </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"<br />                                SELECT *<br />                                FROM gaestebuch<br />                                WHERE aktiviert='1'<br />                                ORDER BY datum DESC LIMIT 10"</span><span class="syntaxkeyword">;<br /><br />            </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br />            </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$qryAlleEintraege </span><span class="syntaxkeyword">);<br /><br />            if ( ! </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">)<br />                {<br />                    die(</span><span class="syntaxstring">'Ungültige Abfrage: ' </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">mysql_error</span><span class="syntaxkeyword">());<br />                }<br /><br />            </span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<br />            </span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br />            echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />            while (</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">))<br />                {<br />                    </span><span class="syntaxcomment">// Ausgabe der Daten<br />                    </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br />                    echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br />                    echo </span><span class="syntaxstring">"Message: <br /><br />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />                }<br /> </span><span class="syntaxdefault"></span>

CyberGirl · 23. Mai 2011

Probiers mal damit:

PHP

<span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /></span><span class="syntaxcomment">//-----------------------------------------------<br />// Schritt 1 - Alle Eintraege zaehlen<br />//-----------------------------------------------<br /></span><span class="syntaxdefault">$qryAlleEintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $qryAlleEintraege </span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br />}<br /><br /></span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxcomment">//-----------------------------------------------<br />// Schritt 2 Anzeige der Anzahl der Einträge<br />//-----------------------------------------------<br /><br /><br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxcomment">//-------------------------------------------------------<br />// Schritt 3 Alle aktivierten Eintraege aus der DB lesen<br />//-------------------------------------------------------<br /><br /></span><span class="syntaxdefault">$qry </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT * FROM gaestebuch WHERE aktiviert='1' ORDER BY datum DESC LIMIT 10"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">$eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$qry</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault">$eintraege</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br />}<br /><br /></span><span class="syntaxcomment">//-----------------------------------------------<br />// Schritt 4 Ausgabe der aktivierten Eintraege<br />//-----------------------------------------------<br /><br /></span><span class="syntaxdefault">while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $eintraege</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br />{<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"Message: <br /><br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />}<br /><br /></span><span class="syntaxcomment">//-----------------------------------------------<br />// Schritt 5 Freigeben der Ressourcen<br />//-----------------------------------------------<br /><br /></span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintraege</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">?><br /></span></span>

Willst Du eigentlich die Anzahl aller Eintraege haben oder nur die aktivierten ?

LG

revils · 23. Mai 2011

Nur die der aktivierten

CyberGirl · 23. Mai 2011

Hi,

Zitat

Nur die der aktivierten

dann musst Du die Abfrage leicht aendern.

Code

$qryAlleEintraege = "SELECT * FROM gaestebuch WHEER aktiviert = '1' ";

LG

revils · 23. Mai 2011

Alles klar, danke...hat alles funktioniert!

Gästebuch Anzahl Einträge wird nicht aktualisiert

Jetzt mitmachen!

Teilen