Can anyone help me with the logic for this one please ...
I have a table which has n number of pics in it.... I want to select 5 random pics (making sure that none are the same) and then display them on the screen.
I have this muddled up code so far ....
<cfquery name="GetPics" datasource="#application.DSN#">
select *
from tblindexpics
order by ID desc
</cfquery><cfset piclist="">
<cfloop index = "LoopCount" from = "1" to = "5">
<cfoutput query="GetPics">
<cfset piclist=listappend(piclist,#id#)>
</cfoutput>
<cfset picnumber=randrange(1,listlen(piclist))>
<cfset pictoget=listappend(listgetat(piclist,picnumber),#LoopCount#)>
</cfloop><cfquery name="views" datasource="#application.DSN#">
select *
from tblindexpics
where id = #(whatgoes her??)#
</cfquery>I've lost the plot completely and am confused as to what loop goes where, when & why.
Regards - Paul
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
