Mysql- how to select last 100 records from a table

Question

This is php/mysql code

$view->pch = $db->Query("SELECT from_unixtime(`pauc_date`), `pauc_ad_id`, `pauc_domain`, `pauc_word`, `pauc_referer`, `pauc_ip`, `pauc_country` FROM publisher_ad_units_clicks WHERE pauc_user_id=?", "i", $USER_ID);

I need to change this query to get only last 100 rows. because table has thousands of rows and slow down the page loading.

sagi · Accepted Answer · 2016-06-19 09:34:37Z

1

You can use MySQL ORDER BY..LIMIT:

SELECT from_unixtime(pauc_date), pauc_ad_id, pauc_domain, pauc_word, pauc_referer, pauc_ip, pauc_country FROM publisher_ad_units_clicks where pauc_user_id=? ORDER BY pauc_date DESC LIMIT 100

answered Jun 19, 2016 at 9:34

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

sagi Over a year ago

What do you mean by 'not working' , is it throwing an error? not the correct results?

Tharindu Gallage Over a year ago

i think problem with, where pauc_user_id=? page not loading HTTP ERROR 500

Tharindu Gallage Over a year ago

problem with using ORDER BY pauc_date DESC LIMIT 100 after pauc_user_id=?","i",$USER_ID

Tharindu Gallage Over a year ago

thisis my full code with your answer $view->pch = $db->Query("SELECT from_unixtime(pauc_date), pauc_ad_id, pauc_domain, pauc_word, pauc_referer, pauc_ip, pauc_country FROM publisher_ad_units_clicks where pauc_user_id=?","i",$USER_ID ORDER BY pauc_date DESC LIMIT 100 );

Ranjeet Singh · Accepted Answer · 2016-06-19 12:39:22Z

You need to use limit in your mysql query. Reference

$view->pch = $db->Query("SELECT from_unixtime(`pauc_date`), `pauc_ad_id`, `pauc_domain`, `pauc_word`, `pauc_referer`, `pauc_ip`, `pauc_country` FROM publisher_ad_units_clicks WHERE pauc_user_id=? LIMIT 0, 100", "i", $USER_ID);

Collectives™ on Stack Overflow

Mysql- how to select last 100 records from a table

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related