Select last two rows from mysql php

Mrigank Published at Dev

Mrigank

I have a database like this:

+----------+----------+------+
| username | password | time |
+----------+----------+------+
| a        | b        | 1234 |
| c        | d        | 5678 |
| e        | f        | 9012 |
+----------+----------+------+

Now I have to arrange this by time so I ran:

mysql_query("SELECT * FROM `table` ORDER BY `time`")

This showed me rows arranged by time in ascending order, but I have to get only username c and e or I have to get the last two rows from the query.

I have tried:

mysql_query('SELECT * FROM `table` ORDER BY `time` LIMIT 2')

But this showed me usernames a and c but I have to get the last two, how to do that?

Nathan

SELECT * FROM table
ORDER BY time DESC
LIMIT 2

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-7

Comments

0 comments

From Dev

mysql - select last two rows in query

From Dev

Select last N rows from MySQL - codeigniter

From Dev

Select last N rows from MySQL - codeigniter

From Dev

Select the last date from multiple rows in mysql

From Dev

PHP MySQL select two random rows but not with rand()

From Dev

PHP and MySql - fetching rows from two tables

From Dev

Select rows from two different tables but order by date using php and MySQL

From Dev

MySQL: select last (max) value from column and count of all rows

From Dev

How to select non-matching rows from two mysql table

From Dev

MySQL select row with two matching joined rows from another table

From Dev

Mysql statement to select distinct rows from two columns

From Dev

Mysql statement to select distinct rows from two columns

From Dev

mysql select from table where two (or more) rows match,

From Dev

Mysql Select Two Rows in One

From Dev

Select last rows in MySQL and stop on matching condition

From Dev

PHP Select from MySQL table and return column with most rows

From Dev

how to select alternate rows from mysql using php

From Dev

MySQL PHP insert data from two rows into multidimensional array

From Dev

MySQL select all rows from this year to a specific month from last year

From Dev

How to select rows in MySQL/PHP?

From Dev

PHP MySQL select rows where date time value within the last n minutes

From Dev

Doctrine - select last 4 rows from table

From Dev

Doctrine - select last 4 rows from table

From Dev

Select all rows from last inserted

From Dev

MySQL select the last two inserted IDs

From Dev

MySQL concurrent select from rows

From Dev

Select multiple rows from MySQL

From Dev

Query syntax with php variables to select from two MySQL tables

From Dev

mysql select rows based on two columns

Related Related

Article