MYSQL random row 1

[peacecodotnet]

I am using php to read from a table in a mysql database. I need to be able to run a select statement that selects * where field1='value1' and field2='value2'

I know how to do that, but then I need to select a random row from those results. How do I do that?

Any help would be greatfully appreciated.

Peace out,
Peace Co.

 

[Olavxxx]

I have an example for you.

Natural join, with random, 30 rows

sql = 'SELECT cat_id, cat_title, word_id, word_word'
        . ' FROM `hangman_cat` , `hangman_words` '
        . ' WHERE word_cat_id = cat_id'
        . ' ORDER BY RAND( ) LIMIT 0, 30';

If you want only one result:

SELECT <field(s)> FROM <table(s)> WHERE <clause(s)> AND <clause(s)> ORDER BY RAND( ) LIMIT 0, 1

 

[peacecodotnet]

Thank you SO much this really helped.

Peace out,
Peace Co.

 

[Olavxxx]

no problem
it's very cool for "random pics", "random quotes", etc.
I see a lot of people do a random function in php, but it's always best to do it in the sql database, if you can.

 

[chessbot]

Just out of curiousity, is there a random function built into PHP (like Math.random() in Javascript or Java)?

--Chessbot

"So it goes."
Kurt Vonnegut, Slaughterhouse Five

 

[Olavxxx]

Here, made for you! (now)

echo genRandom();

function genRandom($from = 1, $to = 10)
  {
    return rand($from, $to);
  }

 

[chessbot]

so rand($a,$b) generates a random number?

makes sense...
Thanks.

--Chessbot

"So it goes."
Kurt Vonnegut, Slaughterhouse Five

 

[Olavxxx]

rand needs a start and a stop.. $a, $b or whatever you might want to call it.

If called without the optional min, max arguments rand() returns a pseudo-random integer between 0 and RAND_MAX. If you want a random number between 5 and 15 (inclusive), for example, use rand (5, 15).

reference:

http://php.net/manual/en/function.rand.php

 

[chessbot]

that is much better than Math.random()!

--Chessbot

"So it goes."
Kurt Vonnegut, Slaughterhouse Five

 

[Olavxxx]

yeah.. I think php is quite easy.. atleast when you know what you need to do

or wait, so is life.