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>