In article <[EMAIL PROTECTED]>,
 [EMAIL PROTECTED] (Matthew Delmarter) wrote:

> 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

select * from table order by rand() limit 3

See the manual at myql.com for more info on the "rand()" function and 
"limit" keyword.

-- 
CC

-- 
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]

Reply via email to