Posted by strawberry on 06/22/06 06:17

in the query itself you could add 'order by rand() limit 4'

vito wrote:
> after executing the query, say it returns 1000 results.
>
> if i just want to do some sampling and like to have a look on 4 of them,
> how can i refer to these 4 random records out of 1000? i'm working on
> processing the result of $res_array which has 1000 records.
>
> query = select * from test;
>
> result = mysql_query(query);
>
> records1000 = db_result_to_array($result);
> //how to select/remove records1000 to get say, records4?
>
>
> function db_result_to_array($result) {
> $res_array = array();
> for ($count=0; $row = $result->fetch_assoc(); $count++) {
> $res_array[$count] = $row;
> }
> return $res_array;
> }

• Next in forum: Re: Subdomains Retaining The Logos From The Root Domain
• Prev in forum: question about processing MySQL query result
• Thread view: Re: question about processing MySQL query result

[Reply to this message]