[SOLVED] SQL SELECT + random

[chocopi]

How would i go about selecting information from a table and then picking a random one out of the selected

 

<?php
$1 = mysql_query("SELECT id FROM Mark WHERE id > 0");
rand($1);
?>

 

or something like that

 

Thanks,

 

~ Chocopi

[taith]

not tested... but it should work :-)

<?php
$query=mysql_query("SELECT id FROM Mark WHERE id>0 ORDER BY rand(), LIMIT 1");
$row=mysql_fetch_assoc();
print_r($row);
?>

[egorig]

Another one ...

 

<?

$query = mysql_query ("SELECT id,name FROM table WHERE id>0");

 

$rand = rand(0,10);

 

$result = mysql_result($query,$rand,"name");

 

echo $result;  // this will display a random name from the table with names.

?>

[chocopi]

cheers taith but it wasnt working so i put mysql_error in there and it returned:

 

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

 

egorig, thanks i shall try yours in a mo

 

~ Chocopi

[cmgmyr]

<?php
$result = mysql_query("SELECT id FROM Mark WHERE id > 0 ORDER BY RAND() LIMIT 1");
?>

 

This should work like taith said. It's always faster if you can just do it in the query itself

[taith]

lol... right... no , after rand()... lol

[chocopi]

thanks for all your help guys, but

 

this is what i ended up with:

 

<?php
$query = mysql_query("SELECT id FROM table WHERE id>0 ORDER BY rand() LIMIT 1");
$row = mysql_fetch_assoc($query) or die(mysql_error());
$blah = $row['id'];
echo $blah;
?>

 

However it is only returning 1 and none of the other values

 

~ Chocopi

[taith]

a) your only selecting the id

b) your only echoing the id

c) you've limited it to one row... you'll only ever get, one row...

[chocopi]

ive changed

 

echo $blah;

 

to

 

print ("Hello $blah ");

 

and its working fine, strange

 

Anyways, thanks for your help

 

~ Chocopi