Displaying Random Record can be made only by using SQL statement, without your hard-work to write a script or program. There is in the SQL function RAND (). This function can generate random numbers.
By default, this function will result in real numbers range from 0 - 1.
Example usage: SELECT RAND ();
Above statement will produce output random real numbers range from 0 - 1.
Function RAND () in the example above is placed in the SELECT. But you can also put it in the ORDER BY.
Example usage: SELECT * FROM table ORDER BY RAND ();
Well ... if the above statement will show a record that will be selected at random among all the records in the table.
You may then ask, what if you want to select N records at random from all that is in the table? The way that is easy enough just by adding a LIMIT command N.
Example usage: SELECT * FROM table ORDER BY RAND () LIMIT 3;
Statement on the record will show random 3.
You can also use the WHERE, as in the following statement SELECT * FROM table WHERE conditions ORDER BY RAND () LIMIT 3;
Miraculously ... let's say you choose N random records with a SQL statement above, then the N records are not the same.
2 komentar:
nice post brother....
moga bermanfaat
Posting Komentar