Jump to content
SkyRanger

Select random but limit 1 to show from last 10 entries

Recommended Posts

Right now I have a little over 400 entries but I am trying to figure out how to only pull 1 entry from the last 10 inserted.  Currently I have:

SELECT * FROM $tablename ORDER BY RAND() LIMIT 1

I do know I need to do order by kuid asc  but not sure how to pull 1 out of the last 10 inserted randomly on page refresh.

Share this post


Link to post
Share on other sites

SELECT * FROM
    (
    SELECT * FROM $tablename ORDER BY id DESC LIMIT 10
    ) last10
ORDER BY RAND() LIMIT 1;

(if recs have timestamp, use that to get latest 10 records)

Edited by Barand

Share this post


Link to post
Share on other sites

It does Barand. Thank you.  Shows how much I know about sql.  Did not know you could use a select within a select.  Learning something new every day.

Share this post


Link to post
Share on other sites
3 hours ago, SkyRanger said:

select within a select

It is called a Subquery. Now you know the proper term so you can look it up and learn about it.

Share this post


Link to post
Share on other sites
5 hours ago, SkyRanger said:

Did not know you could use a select within a select.  Learning something new every day

That particular subquery creates a temporary table called "last10" which contains your last ten records. See the link in my sig.

Share this post


Link to post
Share on other sites

Thank you to the both of you.  I am almost 50, doing this late in life and self teaching with the help of great people like you.  Thank you again.

Share this post


Link to post
Share on other sites
2 minutes ago, SkyRanger said:

I am almost 50

Ah! Those were the days. Oh to be young again 😊

Share this post


Link to post
Share on other sites
34 minutes ago, Barand said:

Ah! Those were the days. Oh to be young again 😊

Yeah I forgot old feller...lol

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.