Select random database value?

[nikesh.yadav]

I m working on advertise website for that i need to select random values from the database
so please help me

Thanx in advance

[nikesh.yadav]

i Got the result myself and answer is

SELECT * FROM tablename ORDER BY Rand() LIMIT 0,30

bye

[Vledic]

i Got the result myself and answer is

SELECT * FROM tablename ORDER BY Rand() LIMIT 0,30

bye

Hey thanks allot for the information... just have a small question about the 0,30 numbers in the code, those mean how many units of data will choose¿¿

[anupam294]

<?php
ob_start();
include("conn.php"); //connection file
$sql = "select* from tablename order by rand()"; (rand is function of php not a field)
$query = mysql_query($sql);
$data = mysql_fetch_array($query);

?>

<?php echo $data['m'];?> ( m is field name )

thanks