php做一个排名,根据时间排名
php做一个排名,根据时间排名,图中是按时间倒序排的,排队字段需要按时间正序排。
正确的排队顺序与序号反过来了5.4.3.2.1
回复讨论(解决方案)
我是掌握魔法的大师!
不是order by time就行了么
如果按id 逆序排可以这样写
select * from table order by id desc;
不是order by time就行了么
这个方法是可以,但是前面的序号是按 desc,而后面的排队是按asc,所以纠结呀。老板太挑剔了
你的 排队 列并没有数据
order by 字段
desc or asc
升序 desc
降序 asc
你的 排队 列并没有数据
恩,没有数据,序号列是$key,就是按降序排的。排序列需要按升序排,sql语句只能排一次。所以现在正纠结呢。初步打算是增加个字段,然后写一条循环语句,把排名写到这个字段里。不停地循环id,这样每条数据就有了排序字段的值了。可是不会根据ID循环
那你排名的依据是什么呢?
那你排名的依据是什么呢?
排名的依据是时间升序,而序号的依据是时间降序。所以两个冲突了
你的序号是输出时 php 代码产生的
那么你的排名就是 总数-序号
序号 排名1 52 43 34 2 5 1
你的序号是输出时 php 代码产生的
那么你的排名就是 总数-序号
序号 排名1 52 43 34 2 5 1
太对了,我就是想要这种效果。怎么做出来的?具体帮我说说吧,我不明白
取得查询结果的总记录数不是很难吧?
那么
echo '序号'.$i.' 排名' . ($count-$i);
$i++;
不就行了?

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
