 |
Tony
User
Feb 17, 2003, 10:26 AM
Post #1 of 10
(3238 views)
Shortcut
|
|
Featuring homes on first page of site - rotate or featured
|
Can't Post
|
|
I have read many posts that state that Realty Manager is not set up to display random listings on a main homepage, but I ask if anyone has been successful using Server Side Includes (SSI) to achieve this type of thing. I think that SSI would only generate one listing - based on a custom search string.
So, on the main page, let's say index.htm, in addition to all the intro stuff about the realtor, have a cell that rotates a featured home (or even a featured agent, too). I have set up the listing fields to include a yes/no designation. I have a custom page that pulls a search result for featuredkeyword=yes, and that works fine. How can I take it a step further and include this inside another page.
Thanks, Tony
|
|
| |
|
Benjamin
Staff
Feb 17, 2003, 3:49 PM
Post #2 of 10
(3225 views)
Shortcut
|
|
Re: [Tony] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
Hi Tony,
Yes, you're quite right. Realty Manager isn't really equipped for this.
The problem with pulling in a random listing is knowing how to uniquely identify it. If listings were simply stored numerically with numbers 1 through x (the total number of listings in your database), you could simply write some javascript to randomly generate a number between those values, and use it to query the database, thus retrieving a random listing.
But it's not that simple, unfortunately. If you were delete a listing, there'd be a hole made in your database - there wouldn't be anything in that value; and, as such, if the javascript was unlucky enough to draw that number, there'd be nothing to retrieve from the database - it would yield an error message.
However, it's possible if you were to do this:
- off the top of my head, what you could do is store a bunch of number corresponding to the listing numbers in an external file, then using some sort of scripting language (even javascript would work), to randomly pick one, then use it to pull the listing.
This gets around the above problem in that you'll KNOW the numbers are all valid, and correspond to a viable listing.
Hope this puts you on the right track.
Ben
interactivetools.com
|
|
| |
|
Joey
User
Feb 28, 2003, 2:25 PM
Post #3 of 10
(3110 views)
Shortcut
|
|
Re: [Benjamin] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
Just a quick hypothetical question...If on the main site page (homepage not being a template page)...any thoughts on including an I-Frame of your _publish_index.html page??? and making the template for all the listings a manageable size to place on a homepage?? say 450x250...I know for a large database of properties/cars this could get to large but if only 50-100 might be useful...any thoughts on compatability using an I-frame
Joey
http://Used-CarLots.com
Joey Stubblefield
http://Used-CarLots.com
Powered By Auto Manager!
http://1000Cars.com
Powered By Auto Manager!
http://MeetingStreetMotors.com
Powered By Used-CarLots.com Via Auto Manager!
|
|
| |
|
Benjamin
Staff
Mar 2, 2003, 9:03 AM
Post #4 of 10
(3074 views)
Shortcut
|
|
Re: [Joey] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
Hi Joey,
Yes, that sounds fine. One thing you might consider is using frames instead of iframes. Take a look at this page: http://www.webreview.com/browsers/browsers.shtml
As you can see, frames are more commonly supported than iframes. It's not all that significant - the commonly-used browsers run both, but it's still worth noting.
But regardless of which you choose, it sounds like a perfectly reasonable idea.
Ben
interactivetools.com
|
|
| |
|
ors
User
Mar 6, 2003, 2:12 AM
Post #5 of 10
(2985 views)
Shortcut
|
|
Re: [Tony] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
We are currently rotating featured listings on our homepage with every page load. If you have MySql access we might be able to help you out.
http://www.onlinerealtysales.com
(This post was edited by ors on Mar 6, 2003, 2:17 AM)
|
|
| |
|
trevor
New User
Mar 7, 2003, 3:27 AM
Post #6 of 10
(2944 views)
Shortcut
|
|
Re: [ors] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
We'd like to do this with Auto Manager, we do have MySQL access. Can you give me a taste of how much we'd have to do to change over to MySQL, it's not a production site yet. So there's no data to worry about.
|
|
| |
|
ors
User
Mar 7, 2003, 3:52 AM
Post #7 of 10
(2941 views)
Shortcut
|
|
Re: [trevor] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
Personally I would pull all of the featured car data into mysql. Once in mysql you can munipulated quite a bit faster since you are not parsing the entire listing.dat.cgi file.
You can email me directly to discuss this further. programming@onlinerealtysales.com
|
|
| |
|
trevor
New User
Mar 7, 2003, 3:57 AM
Post #8 of 10
(2939 views)
Shortcut
|
|
Re: [ors] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
Sounds like a better idea, much more stramlined, can cross reference to other sites et.al.
Have you got the code for the input to MySQL already done for Realty?
If you have can you let us have a look at it?
|
|
| |
|
ors
User
Mar 7, 2003, 4:14 AM
Post #9 of 10
(2935 views)
Shortcut
|
|
Re: [trevor] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
You might be better off talking to Melissa at melissa@onlinerealtysales.com she should be able to help you out further.
|
|
| |
|
trevor
New User
Mar 7, 2003, 4:15 AM
Post #10 of 10
(2932 views)
Shortcut
|
|
Re: [ors] Featuring homes on first page of site - rotate or featured
[In reply to]
|
Can't Post
|
|
thanks
|
|
| |
|
