Spotlight script [SELECT ONLY VIA USERS IN DATABASE]

Thanks for your help.

PHP Code:

---

<?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 xD

Quote:

---

Originally Posted by Independent

Thanks for your help.

PHP Code:

---

<?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 xD

---

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

PHP Code:

---

$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>'; 


---

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

Would be less code, worth a try...

If you use Mysql rand its slower to execute.

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.

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

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.