Problem with ORDER BY RAND()

[Rory_M]

Can anyone help me with this, every time i echo it out it just returns "Array".

 

$sql = mysql_query("SELECT `W_Name` FROM `weapons` ORDER BY RAND() LIMIT 1");
$found_sql = mysql_fetch_array($sql);
echo $found_sql;

 

Thanks for the help in advance. :)

[Lithium]

you are not forgetting anything? echo $found_sql['W_Name'];

[Rory_M]

Oh right i forgot that lol.

[Dominion]

Using order by rand() should be avoided. http://jan.kneschke.de/projects/mysql/order-by-rand/

[Mufasa]

also, I find the best way to quickly echo an array to be print_r( $array ) - though there are certainly other options

[Rory_M]

Thanks Dominion and Mufasa. :)

[a_bertrand]

I would personally do it like that:

For small table, order by rand is a solution...

For bigger tables DO NOT use it instead:

"SELECT COUNT(*) FROM MY_TABLE"

"SELECT * FROM MY_TABLE LIMT ".rnd($maxrow).",1

[Rory_M]

Thanks a_bertrand. :)