Data from database of last 10 newest

esel

I just wanna show last 10 or 30 depends on list if there is big data, searched over the net but all by correcting I can see only the 1st data not newest one.

$sql = "SELECT id, tag, count FROM url ORDER BY id, tag, count ASC LIMIT 1";

I am testing with two datat on database and want to display last one but all the time it shows the oldest one (first data), I changed ASC and DESC also, both time result is same.

Rahul Saxena

Use this one:

$Query = "SELECT id, tag, count FROM url ORDER BY id DESC LIMIT 10"

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Data from database of last 10 newest

From Dev

Read the last (newest) Line from a RichTextBox

From Dev

Reading from serial but only take the newest data

From Dev

How to get the last 5-10 message from a database?

From Dev

Doctrine get 10 most recent records sorted from oldest to newest

From Dev

Node JS | Grabbing last 7 days of data from the database

From Dev

Spring Data JPA Java - get Last 10 records from query

From Dev

Spring Data JPA Java - get Last 10 records from query

From Dev

how can I leave only last 10 newest files in a dir using java?

From Dev

how can I leave only last 10 newest files in a dir using java?

From Dev

MySQL get newest data of user from every table

From Dev

I want to retrieve last year record from MySQL database but it's retrieving all data's from database

From Dev

Firebase on IOS 10 not loading data from Database on real device

From Dev

How to retrieve last six months data from database and group monthly data

From Dev

Malfunction linq - the newest entry in the database

From Dev

Mysql: Sorting newest comments to be the first and newest replies on each comment to be the last

From Dev

Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database

From Dev

matplotlib scatter, pull data from column, only show newest data point

From Dev

Displaying data from database in PHP, first and last name going into same column

From Dev

Codeigniter: how to get data between today and last 15 days from database

From Dev

Get data between current date to last month date from SQLite database

From Dev

Get data between current date to last month date from SQLite database

From Dev

Getting a list of the repeated last form data when trying to fetch the list of objects from database

From Dev

Error while deleting last two rows data with condition from database in Android it deletes only 1 row

From Dev

Select the newest data in an SQL table?

From Dev

DataTable Not Being Updated With Newest Data

From Dev

Android Sql database just gives last data

From Dev

I want to order my data from newest to oldest using Cloud Firestore in Android using Java

From Dev

Getting newest document from internet

Related Related

  1. 1

    Data from database of last 10 newest

  2. 2

    Read the last (newest) Line from a RichTextBox

  3. 3

    Reading from serial but only take the newest data

  4. 4

    How to get the last 5-10 message from a database?

  5. 5

    Doctrine get 10 most recent records sorted from oldest to newest

  6. 6

    Node JS | Grabbing last 7 days of data from the database

  7. 7

    Spring Data JPA Java - get Last 10 records from query

  8. 8

    Spring Data JPA Java - get Last 10 records from query

  9. 9

    how can I leave only last 10 newest files in a dir using java?

  10. 10

    how can I leave only last 10 newest files in a dir using java?

  11. 11

    MySQL get newest data of user from every table

  12. 12

    I want to retrieve last year record from MySQL database but it's retrieving all data's from database

  13. 13

    Firebase on IOS 10 not loading data from Database on real device

  14. 14

    How to retrieve last six months data from database and group monthly data

  15. 15

    Malfunction linq - the newest entry in the database

  16. 16

    Mysql: Sorting newest comments to be the first and newest replies on each comment to be the last

  17. 17

    Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database

  18. 18

    matplotlib scatter, pull data from column, only show newest data point

  19. 19

    Displaying data from database in PHP, first and last name going into same column

  20. 20

    Codeigniter: how to get data between today and last 15 days from database

  21. 21

    Get data between current date to last month date from SQLite database

  22. 22

    Get data between current date to last month date from SQLite database

  23. 23

    Getting a list of the repeated last form data when trying to fetch the list of objects from database

  24. 24

    Error while deleting last two rows data with condition from database in Android it deletes only 1 row

  25. 25

    Select the newest data in an SQL table?

  26. 26

    DataTable Not Being Updated With Newest Data

  27. 27

    Android Sql database just gives last data

  28. 28

    I want to order my data from newest to oldest using Cloud Firestore in Android using Java

  29. 29

    Getting newest document from internet

HotTag

Archive