Jump to content

How to list the last 10 registry in a table Mysql


sbarros

Recommended Posts

[!--quoteo(post=365939:date=Apr 18 2006, 07:34 AM:name=ToonMariner)--][div class=\'quotetop\']QUOTE(ToonMariner @ Apr 18 2006, 07:34 AM) [snapback]365939[/snapback][/div][div class=\'quotemain\'][!--quotec--]
[code]<?php
$qry = "SELECt * FROM yrtbl ORDER BY sortfield DESC LIMIT 0,10";
$qry = mysql_query($qry);

while ($row = mysql_fetch_assoc($qry)) {
echo $row['bittodisplay'] . "<br>";
}
?>[/code]
[/quote]
There are a error
Please see my code:
[code]function gbindex() {
    global $offset, $kvgbcookie, $PHP_SELF, $scripturl, $gburl, $HTTP_GET_VARS;
    $offset = $HTTP_GET_VARS['offset'];
    $resultado=mysql_query("SELECT count(*) FROM kv_guestbook");
    $linha=mysql_fetch_row($resultado);
    $gbtotal=$linha[0];

    if($offset == "") {
        $offset = 0;
    }
    $stop = $offset + 10;
    //$query = "SELECT * FROM kv_guestbook ORDER BY id DESC LIMIT $offset,$stop";
      <b>$query = "SELECT * FROM kv_guestbook ORDER BY id DESC LIMIT 0,10";</b>
     $result = mysql_query($query) or DIE(mysql_error());

    print("
    <link rel=\"stylesheet\" href=\"$scripturl/style.css\" type=\"text/css\">
    <table cellspacing=\"1\" cellpadding=\"3\" width=\"100%\" border=\"0\">
    <tr>
    <td class=\"otherpages\" width=\"25%\">Páginas:
    <a href=\"$PHP_SELF?offset=0\">1</a>
    ");

    if($gbtotal >= "10") {
        print(" | <a href=\"$PHP_SELF?offset=10\">2</a>");
        if($gbtotal >= "20") {
            print(" | <a href=\"$PHP_SELF?offset=20\">3</a>");
            if($gbtotal >= "30") {
                print(" | <a href=\"$PHP_SELF?offset=30\">4</a>");
                if($gbtotal >= "40") {
                    print(" | <a href=\"$PHP_SELF?offset=40\">5</a>");
                }
            }
        }
    }

    print("
    </td>
    <td align=\"left\" class=\"addentry\"><a href=\"$PHP_SELF?a=add\">Registrar Visita</td>

    </tr>
    <tr>
    <td align=\"center\" class=\"gbheader\"><br><b>Visitantes</b></td>

    <td align=\"center\" class=\"gbheader\"><b>Comentários</b></td>
    </tr>
    ");

    while($entry = mysql_fetch_object($result)) {
        print("
          <tr>
             <td class=\"gbt1\" valign=\"top\"><BR><BR>
                <div class=\"mainname\">Nome: $entry->name</div>
                <div class=\"smallleft\">
                Localidade: $entry->location <br>
                ");
                if($entry->email != "") {
                    print("Email: <a href=\"mailto:$entry->email\">$entry->email</a> <br> \n");
                }
                if($entry->url != "") {
                    print("Homepage: <a href=\"$entry->url\">$entry->url</a> <br> \n");
                }
                if($kvgbcookie) {
                    print("
                    IP: $entry->ip<br>
                    <a href=\"$gburl?a=delete&id=$entry->id\">Deletar</a>
                    ");
                }
                print("
                </div>
             </td>
                <td class=\"gbt2\" valign=\"top\">
                </div><BR><BR>
                <div class=\"smallleft\">
                Data: $entry->date <div class=\"post\">$entry->post</div>
              </td>
          </tr>
        ");
    }

    print("
    </table>
    ");
}

function add() {
    global $PHP_SELF;
    print("
    <center>
    <form action=\"$PHP_SELF\" method=\"post\">


    <input type=\"hidden\" name=\"a\" value=\"addsave\">
    <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">
    <tr>
    <td align=\"right\">Nome:</td><td><input type=\"text\" name=\"name\" size=\"25\"></td>
    </tr>
    <tr>
    <td align=\"right\">Email:</td><td><input type=\"text\" name=\"email\" size=\"25\"></td>
    </tr>
    <tr>
    <td align=\"right\">URL:</td><td><input type=\"text\" name=\"url\" value=\"http://\" size=\"25\"></td>
    </tr>
    <tr>
    <td align=\"right\">Localidade:</td>
    <td>
    <select name=\"location\" >
    <option value=\"0\" SELECTED>-------- selecione --------</option>
    <OPTION VALUE=\"United States\">United States</OPTION>
    <OPTION VALUE=\"Afghanistan\">Afghanistan</OPTION>
    <OPTION VALUE=\"Albania\">Albania</OPTION>
    <OPTION VALUE=\"Algeria\">Algeria</OPTION>
    <OPTION VALUE=\"American Samoa\">American Samoa</OPTION>
    <OPTION VALUE=\"Andorra\">Andorra</OPTION>
    <OPTION VALUE=\"Angola\">Angola</OPTION>
    <OPTION VALUE=\"Anguilla\">Anguilla</OPTION>
    <OPTION VALUE=\"Antarctica\">Antarctica</OPTION>
    <OPTION VALUE=\"Antigua And Barbuda\">Antigua And Barbuda</OPTION>
    <OPTION VALUE=\"Argentina\">Argentina</OPTION>
    <OPTION VALUE=\"Armenia\">Armenia</OPTION>
    <OPTION VALUE=\"Aruba\">Aruba</OPTION>
    <OPTION VALUE=\"Australia\">Australia</OPTION>
    <OPTION VALUE=\"Austria\">Austria</OPTION>
    <OPTION VALUE=\"Azerbaijan\">Azerbaijan</OPTION>
    <OPTION VALUE=\"Bahamas\">Bahamas</OPTION>
    <OPTION VALUE=\"Bahrain\">Bahrain</OPTION>
    <OPTION VALUE=\"Bangladesh\">Bangladesh</OPTION>
    <OPTION VALUE=\"Barbados\">Barbados</OPTION>
    <OPTION VALUE=\"Belarus\">Belarus</OPTION>
    <OPTION VALUE=\"Belgium\">Belgium</OPTION>
    <OPTION VALUE=\"Belize\">Belize</OPTION>
    <OPTION VALUE=\"Benin\">Benin</OPTION>
    <OPTION VALUE=\"Bermuda\">Bermuda</OPTION>
    <OPTION VALUE=\"Bhutan\">Bhutan</OPTION>
    <OPTION VALUE=\"Bolivia\">Bolivia</OPTION>
    <OPTION VALUE=\"Bosnia And Herzegowina\">Bosnia And Herzegowina</OPTION>
    <OPTION VALUE=\"Botswana\">Botswana</OPTION>
    <OPTION VALUE=\"Bouvet Island\">Bouvet Island</OPTION>
    <OPTION VALUE=\"Brazil\">Brazil</OPTION>
    <OPTION VALUE=\"British Indian Ocean Territory\">British Indian Ocean Territory</OPTION>
    <OPTION VALUE=\"Brunei Darussalam\">Brunei Darussalam</OPTION>
    <OPTION VALUE=\"Bulgaria\">Bulgaria</OPTION>
    <OPTION VALUE=\"Burkina Faso\">Burkina Faso</OPTION>
    <OPTION VALUE=\"Burundi\">Burundi</OPTION>
    <OPTION VALUE=\"Cambodia\">Cambodia</OPTION>
    <OPTION VALUE=\"Cameroon\">Cameroon</OPTION>
    <OPTION VALUE=\"Canada\">Canada</OPTION>
    <OPTION VALUE=\"Cape Verde\">Cape Verde</OPTION>
    <OPTION VALUE=\"Cayman Islands\">Cayman Islands</OPTION>
    <OPTION VALUE=\"Central African Republic\">Central African Republic</OPTION>
    <OPTION VALUE=\"Chad\">Chad</OPTION>
    <OPTION VALUE=\"Chile\">Chile</OPTION>
    <OPTION VALUE=\"China\">China</OPTION>
    <OPTION VALUE=\"Christmas Island\">Christmas Island</OPTION>
    <OPTION VALUE=\"Cocos (Keeling) Islands\">Cocos (Keeling) Islands</OPTION>
    <OPTION VALUE=\"Colombia\">Colombia</OPTION>
    <OPTION VALUE=\"Comoros\">Comoros</OPTION>
    <OPTION VALUE=\"Congo\">Congo</OPTION>
    <OPTION VALUE=\"Cook Islands\">Cook Islands</OPTION>
    <OPTION VALUE=\"Costa Rica\">Costa Rica</OPTION>
    <OPTION VALUE=\"Cote D Ivoire\">Cote D Ivoire</OPTION>
    <OPTION VALUE=\"Croatia\">Croatia</OPTION>
    <OPTION VALUE=\"Cuba\">Cuba</OPTION>
    <OPTION VALUE=\"Cyprus\">Cyprus</OPTION>
    <OPTION VALUE=\"Czech Republic\">Czech Republic</OPTION>
    <OPTION VALUE=\"Denmark\">Denmark</OPTION>
    <OPTION VALUE=\"Djibouti\">Djibouti</OPTION>
    <OPTION VALUE=\"Dominica\">Dominica</OPTION>
    <OPTION VALUE=\"Dominican Republic\">Dominican Republic</OPTION>
    <OPTION VALUE=\"East Timor\">East Timor</OPTION>
    <OPTION VALUE=\"Ecuador\">Ecuador</OPTION>
    <OPTION VALUE=\"Egypt\">Egypt</OPTION>
    <OPTION VALUE=\"El Salvador\">El Salvador</OPTION>
    <OPTION VALUE=\"Equatorial Guinea\">Equatorial Guinea</OPTION>
    <OPTION VALUE=\"Eritrea\">Eritrea</OPTION>
    <OPTION VALUE=\"Estonia\">Estonia</OPTION>
    <OPTION VALUE=\"Ethiopia\">Ethiopia</OPTION>
    <OPTION VALUE=\"Falkland Islands\">Falkland Islands</OPTION>
    <OPTION VALUE=\"Faroe Islands\">Faroe Islands</OPTION>
    <OPTION VALUE=\"Fiji\">Fiji</OPTION>
    <OPTION VALUE=\"Finland\">Finland</OPTION>
    <OPTION VALUE=\"France\">France</OPTION>
    <OPTION VALUE=\"France, Metropolitan \">France, Metropolitan </OPTION>
    <OPTION VALUE=\"French Guiana\">French Guiana</OPTION>
    <OPTION VALUE=\"French Polynesia\">French Polynesia</OPTION>
    <OPTION VALUE=\"French Southern Territories\">French Southern Territories</OPTION>
    <OPTION VALUE=\"Gabon\">Gabon</OPTION>
    <OPTION VALUE=\"Gambia\">Gambia</OPTION>
    <OPTION VALUE=\"Georgia\">Georgia</OPTION>
    <OPTION VALUE=\"Germany\">Germany</OPTION>
    <OPTION VALUE=\"Ghana\">Ghana</OPTION>
    <OPTION VALUE=\"Gibraltar\">Gibraltar</OPTION>
    <OPTION VALUE=\"Greece\">Greece</OPTION>
    <OPTION VALUE=\"Greenland\">Greenland</OPTION>
    <OPTION VALUE=\"Grenada\">Grenada</OPTION>
    <OPTION VALUE=\"Guadeloupe\">Guadeloupe</OPTION>
    <OPTION VALUE=\"Guam\">Guam</OPTION>
    <OPTION VALUE=\"Guatemala\">Guatemala</OPTION>
    <OPTION VALUE=\"Guinea\">Guinea</OPTION>
    <OPTION VALUE=\"Guinea-Bissau\">Guinea-Bissau</OPTION>
    <OPTION VALUE=\"Guyana\">Guyana</OPTION>
    <OPTION VALUE=\"Haiti\">Haiti</OPTION>
    <OPTION VALUE=\"Heard And Mc Donald Islands\">Heard And Mc Donald Islands</OPTION>
    <OPTION VALUE=\"Honduras\">Honduras</OPTION>
    <OPTION VALUE=\"Hong Kong\">Hong Kong</OPTION>
    <OPTION VALUE=\"Hungary\">Hungary</OPTION>
    <OPTION VALUE=\"Iceland\">Iceland</OPTION>
    <OPTION VALUE=\"India\">India</OPTION>
    <OPTION VALUE=\"Indonesia\">Indonesia</OPTION>
    <OPTION VALUE=\"Iran\">Iran</OPTION>
    <OPTION VALUE=\"Iraq\">Iraq</OPTION>
    <OPTION VALUE=\"Ireland\">Ireland</OPTION>
    <OPTION VALUE=\"Israel\">Israel</OPTION>
    <OPTION VALUE=\"Italy\">Italy</OPTION>
    <OPTION VALUE=\"Jamaica\">Jamaica</OPTION>
    <OPTION VALUE=\"Japan\">Japan</OPTION>
    <OPTION VALUE=\"Jordan\">Jordan</OPTION>
    <OPTION VALUE=\"Kazakhstan\">Kazakhstan</OPTION>
    <OPTION VALUE=\"Kenya\">Kenya</OPTION>
    <OPTION VALUE=\"Kiribati\">Kiribati</OPTION>
    <OPTION VALUE=\"North Korea\">North Korea</OPTION>
    <OPTION VALUE=\"South Korea\">South Korea</OPTION>
    <OPTION VALUE=\"Kuwait\">Kuwait</OPTION>
    <OPTION VALUE=\"Kyrgyzstan\">Kyrgyzstan</OPTION>
    <OPTION VALUE=\"Lao Peoples Republic\">Lao Peoples Republic</OPTION>
    <OPTION VALUE=\"Latvia\">Latvia</OPTION>
    <OPTION VALUE=\"Lebanon\">Lebanon</OPTION>
    <OPTION VALUE=\"Lesotho\">Lesotho</OPTION>
    <OPTION VALUE=\"Liberia\">Liberia</OPTION>
    <OPTION VALUE=\"Libyan Arab Jamahiriya\">Libyan Arab Jamahiriya</OPTION>
    <OPTION VALUE=\"Liechtenstein\">Liechtenstein</OPTION>
    <OPTION VALUE=\"Lithuania\">Lithuania</OPTION>
    <OPTION VALUE=\"Luxembourg\">Luxembourg</OPTION>
    <OPTION VALUE=\"Macau\">Macau</OPTION>
    <OPTION VALUE=\"Macedonia\">Macedonia</OPTION>
    <OPTION VALUE=\"Madagascar\">Madagascar</OPTION>
    <OPTION VALUE=\"Malawi\">Malawi</OPTION>
    <OPTION VALUE=\"Malaysia\">Malaysia</OPTION>
    <OPTION VALUE=\"Maldives\">Maldives</OPTION>
    <OPTION VALUE=\"Mali\">Mali</OPTION>
    <OPTION VALUE=\"Malta\">Malta</OPTION>
    <OPTION VALUE=\"Marshall Islands\">Marshall Islands</OPTION>
    <OPTION VALUE=\"Martinique\">Martinique</OPTION>
    <OPTION VALUE=\"Mauritania\">Mauritania</OPTION>
    <OPTION VALUE=\"Mauritius\">Mauritius</OPTION>
    <OPTION VALUE=\"Mayotte\">Mayotte</OPTION>
    <OPTION VALUE=\"Mexico\">Mexico</OPTION>
    <OPTION VALUE=\"Micronesia\">Micronesia</OPTION>
    <OPTION VALUE=\"Moldova\">Moldova</OPTION>
    <OPTION VALUE=\"Monaco\">Monaco</OPTION>
    <OPTION VALUE=\"Mongolia\">Mongolia</OPTION>
    <OPTION VALUE=\"Montserrat\">Montserrat</OPTION>
    <OPTION VALUE=\"Morocco\">Morocco</OPTION>
    <OPTION VALUE=\"Mozambique\">Mozambique</OPTION>
    <OPTION VALUE=\"Myanmar\">Myanmar</OPTION>
    <OPTION VALUE=\"Namibia\">Namibia</OPTION>
    <OPTION VALUE=\"Nauru\">Nauru</OPTION>
    <OPTION VALUE=\"Nepal\">Nepal</OPTION>
    <OPTION VALUE=\"Netherlands\">Netherlands</OPTION>
    <OPTION VALUE=\"Netherlands Antilles\">Netherlands Antilles</OPTION>
    <OPTION VALUE=\"New Caledonia\">New Caledonia</OPTION>
    <OPTION VALUE=\"New Zealand\">New Zealand</OPTION>
    <OPTION VALUE=\"Nicaragua\">Nicaragua</OPTION>
    <OPTION VALUE=\"Niger\">Niger</OPTION>
    <OPTION VALUE=\"Nigeria\">Nigeria</OPTION>
    <OPTION VALUE=\"Niue\">Niue</OPTION>
    <OPTION VALUE=\"Norfolk Island\">Norfolk Island</OPTION>
    <OPTION VALUE=\"Northern Mariana Islands\">Northern Mariana Islands</OPTION>
    <OPTION VALUE=\"Norway\">Norway</OPTION>
    <OPTION VALUE=\"Oman\">Oman</OPTION>
    <OPTION VALUE=\"Pakistan\">Pakistan</OPTION>
    <OPTION VALUE=\"Palau\">Palau</OPTION>
    <OPTION VALUE=\"Panama\">Panama</OPTION>
    <OPTION VALUE=\"Papua New Guinea\">Papua New Guinea</OPTION>
    <OPTION VALUE=\"Paraguay\">Paraguay</OPTION>
    <OPTION VALUE=\"Peru\">Peru</OPTION>
    <OPTION VALUE=\"Philippines\">Philippines</OPTION>
    <OPTION VALUE=\"Pitcairn\">Pitcairn</OPTION>
    <OPTION VALUE=\"Poland\">Poland</OPTION>
    <OPTION VALUE=\"Portugal\">Portugal</OPTION>
    <OPTION VALUE=\"Puerto Rico\">Puerto Rico</OPTION>
    <OPTION VALUE=\"Qatar\">Qatar</OPTION>
    <OPTION VALUE=\"Reunion\">Reunion</OPTION>
    <OPTION VALUE=\"Romania\">Romania</OPTION>
    <OPTION VALUE=\"Russian Federation\">Russian Federation</OPTION>
    <OPTION VALUE=\"Rwanda\">Rwanda</OPTION>
    <OPTION VALUE=\"Saint Kitts And Nevis\">Saint Kitts And Nevis</OPTION>
    <OPTION VALUE=\"Saint Lucia\">Saint Lucia</OPTION>
    <OPTION VALUE=\"Saint Vincent And The Grenadines\">Saint Vincent And The Grenadines</OPTION>
    <OPTION VALUE=\"Samoa\">Samoa</OPTION>
    <OPTION VALUE=\"San Marino\">San Marino</OPTION>
    <OPTION VALUE=\"Sao Tome And Principe\">Sao Tome And Principe</OPTION>
    <OPTION VALUE=\"Saudi Arabia\">Saudi Arabia</OPTION>
    <OPTION VALUE=\"Senegal\">Senegal</OPTION>
    <OPTION VALUE=\"Seychelles\">Seychelles</OPTION>
    <OPTION VALUE=\"Sierra Leone\">Sierra Leone</OPTION>
    <OPTION VALUE=\"Singapore\">Singapore</OPTION>
    <OPTION VALUE=\"Slovakia\">Slovakia</OPTION>
    <OPTION VALUE=\"Slovenia\">Slovenia</OPTION>
    <OPTION VALUE=\"Solomon Islands\">Solomon Islands</OPTION>
    <OPTION VALUE=\"Somalia\">Somalia</OPTION>
    <OPTION VALUE=\"South Africa\">South Africa</OPTION>
    <OPTION VALUE=\"South Georgia\">South Georgia</OPTION>
    <OPTION VALUE=\"The South Sandwich Islands\">The South Sandwich Islands</OPTION>
    <OPTION VALUE=\"Spain\">Spain</OPTION>
    <OPTION VALUE=\"Sri Lanka\">Sri Lanka</OPTION>
    <OPTION VALUE=\"St Helena\">St Helena</OPTION>
    <OPTION VALUE=\"St Pierre and Miquelon\">St Pierre and Miquelon</OPTION>
    <OPTION VALUE=\"Sudan\">Sudan</OPTION>
    <OPTION VALUE=\"Suriname\">Suriname</OPTION>
    <OPTION VALUE=\"Svalbard And Jan Mayen Islands\">Svalbard And Jan Mayen Islands</OPTION>
    <OPTION VALUE=\"Swaziland\">Swaziland</OPTION>
    <OPTION VALUE=\"Sweden\">Sweden</OPTION>
    <OPTION VALUE=\"Switzerland\">Switzerland</OPTION>
    <OPTION VALUE=\"Syrian Arab Republic\">Syrian Arab Republic</OPTION>
    <OPTION VALUE=\"Taiwan\">Taiwan</OPTION>
    <OPTION VALUE=\"Tajikistan\">Tajikistan</OPTION>
    <OPTION VALUE=\"Tanzania\">Tanzania</OPTION>
    <OPTION VALUE=\"Thailand\">Thailand</OPTION>
    <OPTION VALUE=\"Togo\">Togo</OPTION>
    <OPTION VALUE=\"Tokelau\">Tokelau</OPTION>
    <OPTION VALUE=\"Tonga\">Tonga</OPTION>
    <OPTION VALUE=\"Trinidad And Tobago\">Trinidad And Tobago</OPTION>
    <OPTION VALUE=\"Tunisia\">Tunisia</OPTION>
    <OPTION VALUE=\"Turkey\">Turkey</OPTION>
    <OPTION VALUE=\"Turkmenistan\">Turkmenistan</OPTION>
    <OPTION VALUE=\"Turks And Caicos Islands\">Turks And Caicos Islands</OPTION>
    <OPTION VALUE=\"Tuvalu\">Tuvalu</OPTION>
    <OPTION VALUE=\"Uganda\">Uganda</OPTION>
    <OPTION VALUE=\"Ukraine\">Ukraine</OPTION>
    <OPTION VALUE=\"United Arab Emirates\">United Arab Emirates</OPTION>
    <OPTION VALUE=\"United Kingdom\">United Kingdom</OPTION>
    <OPTION VALUE=\"US Minor Outlying Islands\">US Minor Outlying Islands</OPTION>
    <OPTION VALUE=\"Uruguay\">Uruguay</OPTION>
    <OPTION VALUE=\"Uzbekistan\">Uzbekistan</OPTION>
    <OPTION VALUE=\"Vanuatu\">Vanuatu</OPTION>
    <OPTION VALUE=\"Vatican City State\">Vatican City State</OPTION>
    <OPTION VALUE=\"Venezuela\">Venezuela</OPTION>
    <OPTION VALUE=\"Viet Nam\">Viet Nam</OPTION>
    <OPTION VALUE=\"Virgin Islands    (British)\">Virgin Islands (British)</OPTION>
    <OPTION VALUE=\"Virgin Islands (U.S.)\">Virgin Islands (U.S.)</OPTION>
    <OPTION VALUE=\"Wallis And Futuna Islands\">Wallis And Futuna Islands</OPTION>
    <OPTION VALUE=\"Western Sahara\">Western Sahara</OPTION>
    <OPTION VALUE=\"Yemen\">Yemen</OPTION>
    <OPTION VALUE=\"Zaire\">Zaire</OPTION>
    <OPTION VALUE=\"Zambia\">Zambia</OPTION>
    <OPTION VALUE=\"Zimbabwe\">Zimbabwe</OPTION>
    <OPTION VALUE=\"Other-Not Shown\">Outro-NĂŁo Mostrado</OPTION>
    </select>
    </td>
    </tr>











<tr>
<td align=\"right\">Comentário:</td><td><textarea  name=\"post\" rows=\"8\" cols=\"30\"></textarea></td>
    </tr>
    <tr>

    <td align=\"right\"><input type=\"submit\" value=\"Postar\"></td><td><input type=\"reset\" value=\"Limpar\"></td>
    </tr>
    </table>
    </form></center>
    ");
}
[/code]
[!--quoteo(post=365966:date=Apr 18 2006, 09:37 AM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Apr 18 2006, 09:37 AM) [snapback]365966[/snapback][/div][div class=\'quotemain\'][!--quotec--]
And exactly what is the error message and where does it occur?
[/quote]
The message error is "Duplicate entry '127' for key 1" when I add a new entry.
I am trying to disable it altogether by locking the table again spammers!
I would like see only 10 registry. I use .htaccess but does not resolve


Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.