try this: random_number = rand(10) record_count = number of rows in table random_row = (record_count-10)+random_number sql = select * from table limit random_row,1 hope this helps, t --- In php-objects@xxxxxxxxxxxxxxx, "Atkinson, Robert" <ratkinson@...> wrote: > > SQL does not have a 'random' keyword that I know of. > > The best you can do is load the latest 10 entries into an array, and then > pick one of the array entries using the mt_rand() function. > > Rob. > > -----Original Message----- > From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On > Behalf Of Anees > Sent: 20 November 2007 13:06 > To: php 4 india; phpgroup1; phpgroup2 > Subject: Random record from latest 10 entries... > > HI > > I need to show a random image from Data base, > and it should be from the latest 10 records > > How can i get it by executing only ONE query? > Please help me > > Regards > Anees Muhammed > _____ > > *********************************************************************************** > Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient > or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. > > Random House Group + 44 (0) 20 7840 8400 > http://www.randomhouse.co.uk > http://www.booksattransworld.co.uk > http://www.kidsatrandomhouse.co.uk > Generic email address - enquiries@... > > Name & Registered Office: > THE RANDOM HOUSE GROUP LIMITED > 20 VAUXHALL BRIDGE ROAD > LONDON > SW1V 2SA > Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 > *********************************************************************************** >
