MySQL Newbie

[Kame]

<?php

$user = "***";
$password = "***";
$db = "my_base";
$table = "questions";

$link = mysql_connect( "localhost", $user, $password ) or die ("Error");

mysql_select_db( $db ) or die ( "Error" );

$query = "select * from questions";
$result = mysql_query($query) or die("Error");
echo("<p>");

while ( $row = mysql_fetch_array($result) ){

   echo "$row[0]\n";
   echo "<br>\n";
   echo "<b>$row[1]</b>";

}

?>

I think you understand the basic function of this code. The problem with this is that it prints out the rows in sequential order from first to last. How should I change the code to make it so that it picks only 10 rows in a random order?

Thanks

[Mordecai]

Your query would be like this:
$query = "select * from ".$table." ORDER BY RAND() LIMIT 0,10";
RAND() is a MySQL function that chooses a random number. By using LIMIT 0,10, it tells it to user RAND() 10 times--once for each result.

By the way, use mysql_fetch_array($result,MYSQL_NUM)-- there is data there that you aren't using. Using MYSQL_NUM will speed up your results.

[Kame]

Thank you so much 😃