why dose this query only return result #1 or #10

[seanpaulcail]

Why does this query only return result 1 or 10?

// query for info box
$query4 = "SELECT * FROM mb_intro_color_blurb";
$result4 = mysql_query($query4)
    OR die(mysql_error()); //for debugging
$num_rows4 = mysql_num_rows($result4);

$query5 = "SELECT *
    FROM mb_intro_color_blurb
    WHERE blurb_id <= '{$num_rows4}'
    ORDER BY rand()
    LIMIT 1";
$result5 = mysql_query($query5)
    OR die(mysql_error()); //for debugging
$db_result5 = mysql_fetch_array($result5);

<?php  { echo $db_result5["intro_blurb_text"]; }?>

mb_intro_color_blurb has 10 different rows of information.

thanks

[twostepted]

is your first query necessary? Have you checked its result? You might make sure that you're getting a good result from that first.

[dnast]

Did you cut out something between the main block of code and

<?php { echo $db_result5["intro_blurb_text"]; }?>

If not, then the php (<? ?>) tags haven't been used correctly.

Also, are you using a loop to display the results? [man]mysql_fetch_array[/man] only retrieves one row of results.

[seanpaulcail]

The first query is necessary to determine the number of rows. The first quey returns the number 10 which is the number of blurbs.

then I want to select a random row from the list of rows/ blurbs.

But the query only presents row/blurb 1 or row/blurb 10 instead of 1 or 2 or 3 or 4 or 5 etc.

Why is this?

thanks

[seanpaulcail]

Here's thje code that fixed my problem

// query for info box
$query4 = "SELECT * FROM mb_intro_color_blurb";
$result4 = mysql_query($query4)
    OR die(mysql_error()); //for debugging
$num_rows4 = mysql_num_rows($result4);

 $number = mt_rand(1,$num_rows4);

$query5 = "SELECT *
    FROM mb_intro_color_blurb
    WHERE blurb_id = '$number'";
$result5 = mysql_query($query5)
    OR die(mysql_error()); //for debugging
$db_result5 = mysql_fetch_array($result5); 

the trick is in this line

 $number = mt_rand(1,$num_rows4);

thanks