My apologies. I did a cursory search for a MySQL RAND() function, but couldn't find one, hence my original post. Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Pete Sent: 22 November 2007 22:54 To: php-objects@xxxxxxxxxxxxxxx Subject: Re: Random record from latest 10 entries... In message <167682.50491.qm@xxxxxxxxxxxxxxxxxxxxxxx>, Anees <anees_muhd@xxxxxxxxx> writes >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 > You would need an autoincrementing ID field, call it imageID, then SELECT image FROM tablename WHERE lnkID=(SELECT(ROUND(MAX( imageID)-RAND()*10)) FROM tablename ); It will need tweaking, but it should humour your tutor... -- Pete Clark *********************************************************************************** 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@xxxxxxxxxxxxxxxxx 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 ***********************************************************************************
