"Matthew Delmarter" <[EMAIL PROTECTED]> wrote:
> How do I return a specific record from a db outside of the query?
>
> Let's say I "select * from table" (using mysql_fetch_object) and get 5
> results. I want to display the 5 results in different / random places
> on the page.
>
> Place 1 - show details for record 3
> Place 2 - show details for record 1
> Place 5 - show details for record 5
>
> How do I do this?
Someone mentioned saving to an array. That's the way to go, but I'm not
sure if the reply was clear.
$i = 1;
while ( $qd= mysql_fetch_object( $rs ) )
{
if ( $i == 1 ) { $var1 = $qd->my_field; }
else if ( $i == 2 ) { $var2 = $qd->my_field; }
...
else if ( $i == 5 ) { $var5 = $qd->my_field; }
}
Then use $var1, $var2, ..., $var5 where needed after the loop finishes. I
may be misunderstanding, so if you really want your query to return 5
records, but want to randomly pick a record for each of 5 random spots on
your page then do this:
$i = 1;
while ( $qd= mysql_fetch_object( $rs ) )
{
$var[] = $qd->my_field;
$i++;
}
Then use array_rand() inside a loop to pull from $var[], removing each
element after it's selected (more efficient) or adding code to ensure the
same element isn't picked twice (less efficient).
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
