Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Instant Website: Realty/Listings/Auto:
Random listing problem

 
 


willydoit
User

May 29, 2009, 3:04 AM

Post #1 of 4 (2728 views)
Shortcut
Random listing problem Can't Post
Hi,

I have a huge problem which will hopefully be easy to resolve, I have limited knowledge of cms builder and php so hope it is just a coding issue.

We have a number of accommodation sections and have set each section on the listings page to display 10 listings per page an example can be seen here http://79.170.44.106/bridlington.net/listings/serviced_list.php (the site is in development so ignore any incidental issues). In this particular section of serviced accommodation we have 39 listings and we find that initial loading shows the page as being 1 of 4 which would seem to add up, however we are finding that throughout the 4 pages some accommodation is being listed a number of times and othewrs arent listed at all. (the site is being accessed by temperary measure so links to detail pages dont work unless bridlington.net/ is added to the path after the ip address but we assume this will be resolved when we change the nameserver details so the domain resolves)

I assumed that upon loading, the page would cache somewhere all the appropriate listings and pre create the required pages, however it seems as though when the next page is selected a new random listing is displayed each time so in effect instead of getting a full random list across 4 pages we are seeing 4 pages of random lists.

This facility is the only reason we upgraded from the numerous licences we have for listings manager so it is imperative that we get this working correctly otherwise I have wasted weeks of work spent getting to where we are now.

I appreciate weekend is coming up but pressures of work mean I will be working on this project over the weekend and would like to know that the issue can be resolved prior to going further down this route.

I feel certain it's something I have overlooked and hopefully a glance at the page above will enable someone with more knowledge than I to see exacxtly what I have done wrong.

I have attached the serviced_list.php file in case you need it.

Thanks in advance


(This post was edited by willydoit on May 29, 2009, 3:42 AM)
Attachments: serviced_list.zip (3.09 KB)


ross
Staff / Moderator


Jun 3, 2009, 9:24 AM

Post #2 of 4 (2587 views)
Shortcut
Re: [willydoit] Random listing problem [In reply to] Can't Post
Hi there.

Thanks for posting!

I had a look at your site and it seems like you've switched it to show all your listings. Does that fix the problem of some listings not showing?

One way to start debugging it would be to make the record number appear next to each title just so you can see if some of the duplicates are actually different records with the same name.

Let me know if you still need a hand with this one and we'll go from there. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Product Specialist
support@interactivetools.com

Hire me!  Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/



willydoit
User

Jun 3, 2009, 10:43 PM

Post #3 of 4 (2559 views)
Shortcut
Re: [ross] Random listing problem [In reply to] Can't Post
Thanks Ross,

I posted the issue in the cms forum and received some helpfull reposnses, unfortunately it seems that out of the box you cannot have a random listing over multiple pages which is a bit of a dissapointment but we can hopefully work around it by linking to pre sorted lists to try to keep the page length down.

It may be something you would wish to look into as far as development goes as I believe the issue to be a severe flaw in the process as it was only by accident that we noticed that the issue caused some listings not to display which when the listings are paid for is not a good thing. It's obviously not as simple to rectify as I initially thought, I like the fact that we can demonstrate a new random listing each time a listing page is viewed but it would seem that the possible solutions suggested would remove that facility.

In a nutshell we need to demonstrate to clients that each time a listing is viewed the results are random order, but for aesthetic purposes it would be helpful to be able to limit the number of records per page without it duplicating entries causing others to not then be displayed.

Thanks


ross
Staff / Moderator


Jun 4, 2009, 12:58 PM

Post #4 of 4 (2535 views)
Shortcut
Re: [willydoit] Random listing problem [In reply to] Can't Post
Hi there.

Thanks for getting back to me :).

I actually have a better idea of what you are saying now. The problem you were running into is that when you have your lists set to randomly order your properties, it's also randomizing the second page (when you click the next link).

Basically, it's just a random collection of 10 listings each time. There isn't really an easy way to tell the second page what listings had already appeared on the first page so the lists don't always contain everything and will usually have duplicates from page to page.

By having everything appear on one page, you can do the random ordering again and all your listings will appear.

Or there is probably some fancy SQL we can explore together that will say on page 1, display the first 10 listings in a random order and then on page 2 display the second 10 listings in a random order.

That's going to start getting kind of tricky though. If your current solution works for the time being, you may as well continue on with setting up the demo for your client.

Let me know if this is something you wanted to go over in more detail though :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Product Specialist
support@interactivetools.com

Hire me!  Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/