[waherne]

PPN,

I was reviewing this thread and also the code for the hack.

I'm not a programmer but would this be a solution?!!!!

I think that the problem relates to the mysql query and the 'order by rand()' instruction.

Would this solution work?

1. Query the database but exclude the order by rand() referred to above.
2. Count the no of rows in the query result/array. Result ='x'.
3. Use a php function to pick a random value 'y' between 0 and x-1.
4. Select row 'y' from the query result/array and use this to display the advert.

What do you think?

Or is there anyone else out there that has the coding skill to implement and test this?

This is a great hack and only needs the last push to make it a super one!

Keep up the good work.

Willie