Display ALL active listings under category list

[marketingsolutions +]

Hi all,

You would think that I would be able to do this myself, but having broken the clients installation of 68 several times this morning, I will ask some people who may already know the answer instead...

Our client has requested that ALL of the active listings are displayed underneath the category list. How could I achieve this?

The client wants this so that they can have their Google maps modules display all available listings underneath the 'All Listings' section.

If anyone can give me couple of pointers, they would be most appreciated!

[Lhotch +]

I dont understand the question. Can you walk us through the user experience in a bit more detail? For example, after hitting your site and seeing the home page, what exactly do you want displayed where?

Also, just because the ads are all displayed doesnt mean they will all be populated on a google map. All the addresses need to be sent to google and plotted.

[marketingsolutions +]

On category.php where the category names are displayed, the client requires that all listings are visiable on this page and paginated and with the map marrkers for each individual listing sowing on the google map

[Mike-N-Tosh +]

I haven't visited how to do this, however I think that you need to consider the implications of it.

I would assume you are referring to the home page right under the categories list.

First, as lhotch has already pointed out, the Google maps wouldn't work in this fashion.

Second, to make the Goggle maps work like that would take some additional custom coding with several calls to the database as well as google for each individual ad being shown.

Third, even though there may not be a lot of ads now, what happens as the site progresses and you have thousands of ads? This would make you home page a mile long and might not even render or could cause a time out of the server.

Just some thoughts,
-Mike

[Lhotch +]

Originally Posted by Mike-N-Tosh

Second, to make the Goggle maps work like that would take some additional custom coding with several calls to the database as well as google for each individual ad being shown.

Ive already got the functionality of displaying a google map under a category listing plotting all the points for a current page on a map built into my google maps module.

http://zygnet.net/41beta3/category.php?cat=canon

Originally Posted by Mike-N-Tosh

Third, even though there may not be a lot of ads now, what happens as the site progresses and you have thousands of ads? This would make you home page a mile long and might not even render or could cause a time out of the server.

He did say with pagination but what he didnt say was how to handle maincats,subcats etc. If someone hits browse are they supposed to see a list cats followed by ads, of just the first cat with its ads underneath it and as you paginate you see the subcats and its ads etc etc etc. This is what I was talking about when I said in more detail but apparently I am asking for too much.

[marketingsolutions +]

Ok, I think we have some wires crossed here...

When you point your browser to category.php, you get a simple table with a list of categories underneath.

Our client wants ALL active listings (paginated,not a massive list!) to display underneath this. Dont ask me why. Underneath the 'All Listing' table, they would like their Google Maps module to display markers for each listing that is currently on display (ie: 10 per page?).

I am more than comfortable with editing / creating PHP code, but what does confuse me is how I might go about pulling all the listings using the 68 Database abstraction layer.

I could do this with in place procedural functions, but this is a very poor way of doing things, I would rather use the internal methods such as Listings->getAllListings() for clarity of code and continuity.

I am sory if I wasnt clear from the outset, and probably sorry again for making it even less clear with this post.

Ben

[Eric Barnes]

To show all listings open category.php and find:
$showlistings='N';

Change to:
$showlistings='Y';

Find:
$options['section']=$sec;
Change to:
if(isset($sec)) {
$options['section']=$sec;
}

[marketingsolutions +]

Cheers Eric!

I think the other two went off on a bit of tagent there..

[Lhotch +]

Originally Posted by marketingsolutions

I think the other two went off on a bit of tagent there..

Yeah, OK. I didnt realize trying to get specifics was a tangent, but hey its your project.

[Mike-N-Tosh +]

My post was being written whilst the original poster replied to you, lhotch. I didn't see it till after I hit post.

Timing is everything.

-Mike