Spotlight script [SELECT ONLY VIA USERS IN DATABASE]

[Independent]

Thanks for your help.

<?php
// MySQL Connect code.

$grab = mysql_query("select * from `habbos`");
$amount = mysql_num_rows($grab);

$random = rand(1, $amount);

$random = mysql_query("SELECT habbonames FROM habbos ORDER BY RAND() LIMIT 1");
$showuser = mysql_fetch_array($random);  
$showusername = $showuser['username'];

echo '<img border="0" src="http://www.habbo.' . $showuser['habbohotel'] . '/habbo-imaging/avatarimage?user='. $showuser['habboname'] .'&action=&direction=4&head_direction=3&gesture=sml&size=l&img_format=png"><br />Hello, '.$showuser['habboname'] .' plays Habbo.' . $showuser['habbohotel'] . '</a>';

?>

+REP for trying to help, which is everyone.. but shane (I think that's his name) got there first

Query is *bobba*'d, I'll fix tomorrow morning.. I'm going to bed, night habboxforum

[Decode]

Thanks for your help.

<?php
// MySQL Connect code.

$grab = mysql_query("select * from `habbos`");
$amount = mysql_num_rows($grab);

$random = rand(1, $amount);

$random = mysql_query("SELECT habbonames FROM habbos ORDER BY RAND() LIMIT 1");
$showuser = mysql_fetch_array($random);  
$showusername = $showuser['username'];

echo '<img border="0" src="http://www.habbo.' . $showuser['habbohotel'] . '/habbo-imaging/avatarimage?user='. $showuser['habboname'] .'&action=&direction=4&head_direction=3&gesture=sml&size=l&img_format=png"><br />Hello, '.$showuser['habboname'] .' plays Habbo.' . $showuser['habbohotel'] . '</a>';

?>

+REP for trying to help, which is everyone.. but shane (I think that's his name) got there first

Query is *bobba*'d, I'll fix tomorrow morning.. I'm going to bed, night habboxforum

For Jack that will still take a long time to execute, i would do;

$ammount = mysql_query ( "SELECT * FROM habbos" );
$ammount = mysql_affected_rows ();
$randomnumber = rand ( "1", $ammount );
$mysql = mysql_query ( "SELECT * FROM habbos WHERE id = '" . $randomnumber );
$showuser = mysql_fetch_array ( $mysql );  

echo '<img border="0" src="http://www.habbo.' . $showuser['habbohotel'] . '/habbo-imaging/avatarimage?user='. $showuser['habboname'] .'&action=&direction=4&head_direction=3&gesture=sml&size=l&img_format=png"><br />Hello, '.$showuser['habboname'] .' plays Habbo.' . $showuser['habbohotel'] . '</a>'; 

[Luckyrare]

You may be better using the MySQL rand function rather than the PHP function

Would be less code, worth a try...

[Decode]

If you use Mysql rand its slower to execute.

[Dentafrice]

The first way is actually better if you have a larger database, RAND is slow on larger rowsets.

It only returns ad hoc random results anyway.

[Luckyrare]

Well if you wanted to remove one of the Habbos, and didnt replace it with the same id - it would be not found...

[Dentafrice]

Well yeah, that is using the first method with auto increment.

You should be able to use RAND() just fine here without it slowing down, but on bigger applications.. no.