显示第 0 - 9 行(总共 10 行，查询耗时 0.0002 秒)[LatestMoodTime: [BLOB - 10B] - [BLOB - 0B]] [英] Showing rows 0 - 9 ( 10 total, Query took 0.0002 sec) [LatestMoodTime: [BLOB - 10B] - [BLOB - 0B]]

问题描述

当有 10 个结果时显示 0-9 是什么意思?这会导致 mysql_num_rows 出现问题

What does it mean showing 0-9 when there are 10 results? this is causing issues with mysql_num_rows

这是MYSQL:

SELECT * 
FROM  `members` 
WHERE (
LOWER(  `RealName` ) LIKE  '%hot%'
OR LOWER(  `UserName` ) LIKE  '%hot%'
OR LOWER(  `Location` ) LIKE  '%hot%'
OR LOWER(  `LatestMood` ) LIKE  '%hot%'
)
ORDER BY  `LatestMoodTime` DESC 
LIMIT 0 , 30

有什么想法吗?

推荐答案

结果数组是从零开始的，所以0-9"表示有10个元素，索引从0开始到9结束.

The result array is zero-based, so "0-9" means there are 10 elements, index starting from 0 and ending at 9.

这篇关于显示第 0 - 9 行(总共 10 行，查询耗时 0.0002 秒)[LatestMoodTime: [BLOB - 10B] - [BLOB - 0B]]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！