How do I get a random value from a database, but then pull in ALL fields on that row?

Let’s say I have some people (not users) and some biographical data in a table. I want to randomize a selection from that table, and then bring in all the fields on that row like birthdate, age, gender, picture, etc. and populate that on my page (ideally I’d like to use this selected random value across several pages).

Even more complicated, I want to select a different random person and bring in that person’s birthdate, age, gender, picture, etc. on a different set of pages.

I am so lost and have no idea how to do that. Thanks.

I am not sure I get what you mean? Lets say you have a table called ‘People’, with fields

  1. Birthdate
  2. Age
  3. Gender
  4. Picture

If you want a random entry, you can do a search for people: Random Item and then print the fields you want?

I don’t know how to do that and keep it the SAME random person though, especially across multiple queries or multiple screens.