Brian, if you are tracking the page impressions select the lowest page impression to go first, that seems to be the way most banner apps work. - wont work great if you add new images into the table
Steve Soars ---------------------------------------------------------------------------- ---- www.i-redlands.net Interactive Redlands Shop 2 Cleveland Town Square Cnr Queen & Bloomfield Sts Cleveland QLD 4163 [p] 07 3821-5800 [f] 07 3821-5811 "what we do in life echoes an eternity" ---------------------------------------------------------------------------- ---- ----- Original Message ----- From: "Ryan Sabir" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 10:06 AM Subject: [cfaussie] RE: Loop problem | | Can you check if the recordCount of the query is less than 3, then re-do the | query so it includes the first (number less than 3 ot the recordcount) | records of the query as well as the last 1 or 2? | | We might need to see some of your code to get a better idea of how you are | pulling the ads out. | | seeya! | | | -----Original Message----- | From: [EMAIL PROTECTED] | [mailto:[EMAIL PROTECTED]]On Behalf Of Knott, | Brian | Sent: Friday, 21 February 2003 11:02 AM | To: CFAussie Mailing List | Subject: [cfaussie] Loop problem | | | Hi guy hope you all enjoyed MXDU, been quite on the list the last few day. | No Scott. | | Anyway I'm writing an quick banner program. The problem I have got is | basically this. | | I want to return 3 ads to be displayed. I have a table that contains the | ads. I also have a table that contains the last ad displayed. What I need | to do is get the next 3 ads after the ad displayed, no problems there. The | problem is if its the second last ad or last ad then it needs to go back to | the start of the list and get 1 or 2 ads to make up the 3. I'm presently | using loops. | | Any ideas | | Brian Knott | | --- | You are currently subscribed to cfaussie as: [EMAIL PROTECTED] | To unsubscribe send a blank email to [EMAIL PROTECTED] | | MX Downunder AsiaPac DevCon - http://mxdu.com/ | | | --- | You are currently subscribed to cfaussie as: [EMAIL PROTECTED] | To unsubscribe send a blank email to [EMAIL PROTECTED] | | MX Downunder AsiaPac DevCon - http://mxdu.com/ | --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
