blocks|key|3803389|text|修改您的mysql查询(我假设每个条目都是一个升序id)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3803390|SELECT+*+FROM+blog
ORDER+BY+id+DESC
LIMIT+4;|code-block|syntax|javascript|3803391|但这将使它们的顺序颠倒。如果你想让它们按正确的顺序排列，你可以这样做：|3803392|SELECT+*+
FROM+(
++++SELECT+*+FROM+blog
++++ORDER+BY+id+DESC
++++LIMIT+4
)+last_four
ORDER+BY+id+ASC;|3803393|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Modify your mysql query (i assume that each entry as an ascending id):

<pre><code>SELECT * FROM blog
ORDER BY id DESC
LIMIT 4;
</code></pre>

But this will get them in reverse order. If you want them in correct order you can do:

<pre><code>SELECT * 
FROM (
 SELECT * FROM blog
 ORDER BY id DESC
 LIMIT 4
) last_four
ORDER BY id ASC;
</code></pre>

blocks|key|5418247|text|如果您有一个自动递增的列作为每个博客帖子的id，则可以按降序对id进行排序。使用这样的查询|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5418248|mysql_query("SELECT+*+FROM+blog+ORDER+BY+your_id_column+DESC+LIMIT+4")+|code-block|syntax|javascript|5418249|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you have an auto-incremented column as an id for each blog post, you could sort on the id in descending order. Use a query like this

<pre><code>mysql_query("SELECT * FROM blog ORDER BY your_id_column DESC LIMIT 4") 
</code></pre>

blocks|key|3803336|text|假设您的blog表有一个名为created的列，该列包含帖子的创建日期，此查询应执行所需的操作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3803337|SELECT+*+FROM+blog+ORDER+BY+created+DESC+LIMIT+4|code-block|syntax|javascript|3803338|这将按照最近创建的帖子(按时间)对帖子进行排序，并且只返回从表中获取的前4行。|3803339|entityMap^0|4|4|E|7|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

Assuming your <code>blog</code> table has a column called <code>created</code>, which contains the post's creation date, this query should do what you need:

<pre><code>SELECT * FROM blog ORDER BY created DESC LIMIT 4
</code></pre>

This will order your posts by the most recently created post (time-wise), and will only return the first 4 rows fetched from the table.

blocks|key|1133175|text|您可以对查询执行此操作，将查询更改为如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1133176|select+*+from+blog+order+by+blog_id+desc+limit+4|code-block|syntax|javascript|1133177|您必须将blog_id更改为您使用的任何内容。|offset|length|style|CODE|1133178|entityMap^0|0|0|4|7|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You would do this with the query, changing the query to something like:

<pre><code>select * from blog order by blog_id desc limit 4
</code></pre>

you'll have to change <code>blog_id</code> to whatever you use.

blocks|key|114035|text|使用此查询将按ID降序对记录进行排序，并使用limit仅获取最后4条记录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|114036|SELECT+*+FROM+blog+order+by+ID+DESC+LIMIT+4|code-block|syntax|javascript|114037|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

use this query which will order the records by ID in descending order and fetch only last 4 by using limit.

<pre><code>SELECT * FROM blog order by ID DESC LIMIT 4
</code></pre>

blocks|key|1130646|text|您可以使用LIMIT和ORDER+BY来限制您的SELECT，但为了提供帮助，我们需要更多地了解数据库结构。你能提供"DESCRIBE+blog;“的结果吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1130647|如果你的"id“字段是用auto_increment设置的，那么很可能该字段的数字越高，表明最近的帖子就越多。以相反的顺序显示输出("ORDER+BY+id+DESC")和限制数量("LIMIT+4")应该非常简单。|1130648|++SELECT+*+FROM+blog+ORDER+BY+id+DESC+LIMIT+4;|code-block|syntax|javascript|1130649|在MySQL+documentation上查看SELECT命令的精确结构。|offset|length|1130650|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/select.html^0|0|0|0|1|J|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

You can restrict your SELECT using LIMIT and ORDER BY, but in order to help, we'd need to know a bit more about the database structure. Can you provide the results of "DESCRIBE blog;"?

If your "id" field is set up with auto_increment, then it's a good bet that higher numbers of that field indicate more recent posts. Showing output in reverse order ("ORDER BY id DESC") and restricting the number ("LIMIT 4") should be fairly straightforward.

<pre><code> SELECT * FROM blog ORDER BY id DESC LIMIT 4;
</code></pre>

Check out the precise structure of the SELECT command at the <a href="http://dev.mysql.com/doc/refman/5.5/en/select.html" rel="nofollow">MySQL documentation</a>.

blocks|key|114072|text|<?php

mysql_connect("localhost",+"root",+"root")+or+die(mysql_error());
mysql_select_db("blog")+or+die(mysql_error());

$result+=+mysql_query("SELECT+*+FROM+`blog`+ORDER+BY+`id`+DESC+LIMIT+4")+or+die(mysql_error());++

echo+"<table+border='1'>";
echo+"<tr>+<th>Name</th>+<th>Age</th>+</tr>";
while($row+=+mysql_fetch_array(+$result+))+{
++++echo+"<tr><td>";+
++++echo+$row['id'];
++++echo+"</td><td>";+
++++echo+$row['username'];
++++echo+"</td></tr>";+
}+

echo+"</table>";
?>+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|114073|只需复制并粘贴代码即可。我相信代码会运行得很好。谢谢|unstyled|114074|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>&lt;?php

mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("blog") or die(mysql_error());

$result = mysql_query("SELECT * FROM `blog` ORDER BY `id` DESC LIMIT 4") or die(mysql_error()); 

echo "&lt;table border='1'&gt;";
echo "&lt;tr&gt; &lt;th&gt;Name&lt;/th&gt; &lt;th&gt;Age&lt;/th&gt; &lt;/tr&gt;";
while($row = mysql_fetch_array( $result )) {
 echo "&lt;tr&gt;&lt;td&gt;"; 
 echo $row['id'];
 echo "&lt;/td&gt;&lt;td&gt;"; 
 echo $row['username'];
 echo "&lt;/td&gt;&lt;/tr&gt;"; 
} 

echo "&lt;/table&gt;";
?&gt; 
</code></pre>

Just copy and paste the code. I believe the code will works good. Thanks

ive got this script that echos the information from a mysql database. 
now it all works fine but i only want to echo the last 4 statements inserted

this is the script

<pre><code> &lt;?php

mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("blog") or die(mysql_error());

$result = mysql_query("SELECT * FROM blog") 
or die(mysql_error()); 

echo "&lt;table border='1'&gt;";
echo "&lt;tr&gt; &lt;th&gt;Name&lt;/th&gt; &lt;th&gt;Age&lt;/th&gt; &lt;/tr&gt;";
while($row = mysql_fetch_array( $result )) {
 echo "&lt;tr&gt;&lt;td&gt;"; 
 echo $row['id'];
 echo "&lt;/td&gt;&lt;td&gt;"; 
 echo $row['username'];
 echo "&lt;/td&gt;&lt;/tr&gt;"; 
} 

echo "&lt;/table&gt;";
?&gt; 
</code></pre>

only echoing the last 4 things inserted into a MYSQL database

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我得到了这个脚本，它回显来自mysql数据库的信息。现在一切正常，但我只想回显插入的最后4条语句这就是脚本 <?phpmysql_connect("localhost", "root", "root") or die(mysql_error());mysql_select_db("blog") or die(mysql_error());$result = mysql_

问仅回显插入到MYSQL数据库中的最后4项内容
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问仅回显插入到MYSQL数据库中的最后4项内容EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问仅回显插入到MYSQL数据库中的最后4项内容
EN