Show certain number of rows at random?

Hi,

thanks for your question! Good to hear that you like the plugin so much! ??

It’s not really possible with the Table Row Order Extension from https://tablepress.org/extensions/table-row-order/ but it might be possible by extending the “Display Random Row” Extension from https://tablepress.org/extensions/random-row/

I’ll some research and then post here again shortly.

Regards,
Tobias

You are AWESOME thank you!

Hi,

good news ?? The Extension at https://tablepress.org/extensions/random-row/ now has a parameter that allows setting the desired number of random rows ??

Regards,
Tobias

You are the greatest person on the planet! Next week on payday you’re gonna get a big fat donation. =)

ok let me download and test it, if it’s all good I’ll come back and let you know. Thanks a lot Tobias!

Hi,

no problem, you are very welcome! ?? I hope that it helps!
If there are any problems, just let me know!

And thanks for wanting to donate, I really appreciate that!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

You’re the bomb, it works perfectly! Thanks again for all your work. lol and definitely you’re getting rated! =)

Hi,

great! ?? Thanks for the confirmation, and for the rating! ??

Regards,
Tobias

Hi Tobias, I’m not sure if you’ll see this or if I should open a new thread. I was using this plugin and it works, but I have a couple of questions.

For instance if I had the rows a,b,c,d,e,f,g,h…(and so on)
then the random row plugin would pick a, d, h, j, l but they’d still be in order the way I’d saved it with the top ones at the top and the bottom ones at the bottom. But I wanted it to pick random rows and display them randomly also, so I’d get something more like z, b, t, d, w

Does that make sense? So I decided to use both plugins together so my code is like this: [table id=38 row_order=”random” show_rows=”random” random_rows=”5″/]

Is that the way I’m supposed to do it?

Well most of the time it works, and that brings me to my next question. I’ve noticed that sometimes it doesn’t show the amount of items I told it to – if it’s set at 10, it sometimes shows 8 or 9 only. If it’s set at 5, it may only show 3 or 4. It does it no matter if I include row_order=”random” or not, so I’m not sure what’s going on there. Any ideas?

Hi,

interesting…
I think I may have found a reason for this: The function that retrieves the random rows from the table seems to be doing so based on the array key, by mistake.
To fix this, please try this change:
Change line 42 of the file “tablepress-display-random-row.php” from

$random_rows = array_rand( $rows, (int) $render_options['random_rows'] );

to

$random_rows = array_rand( array_flip( $rows ), (int) $render_options['random_rows'] );

Regards,
Tobias

Man, you’re good at this! ?? Yes that’s exactly it, thank you!

Funny story though, I first copied the line from my email notification instead of coming here to grab it and it threw me a fatal error because it added & #039 ; instead of single quotes…hah, what a dummy I am.

Thanks again for the fix!

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Yeah, that’s something I don’t like about the email notifications. That’s why I always come here to read and reply ??

Best wishes,
Tobias