Complete Listings List

[PFZ_Ken]

Well we have "New Listings", "Featured Listings", "Top Listings" and then categories and sub-categories never mind the "search" function but I am being prevailed upon to come up with a way to show (in a printable format too I'm sure) every listing on our site at least with titles and possibly with a brief summary. I'm not really enthused about it but I must sail this ship as commanded.

I suspect the idea is to have basically an inventory list without photographs.

Is there a way to generate such a list in either alphabetical order or by category?

Thanks for your time,

Ken

[Lhotch]

Originally Posted by PFZ_Ken

Well we have "New Listings", "Featured Listings", "Top Listings" and then categories and sub-categories never mind the "search" function but I am being prevailed upon to come up with a way to show (in a printable format too I'm sure) every listing on our site at least with titles and possibly with a brief summary. I'm not really enthused about it but I must sail this ship as commanded.

I suspect the idea is to have basically an inventory list without photographs.

Is there a way to generate such a list in either alphabetical order or by category?

Thanks for your time,

Ken

top listings just displays the listings with the most views and limits the output to a pre specified number. You could easily use it as the basis for what you want to do, just alter the query to show listing alpha instead of by views and get rid of the limit so it displays all.

[PFZ_Ken]

If someone can write and help me install a mod that will give a link that when clicked on will display a printable plain text list of our complete listings with a no more than two line title/description, PM me.

In our business there are many for whom PCs are not yet effective, productive tools. Most are used to dealing with a printed list be it an auction list or whatever. Again, it does not have to be fancy but it does need to be as easy to read as such a thing can be. I guess in the "old days" I'd need some sort of database app but with PHP and the code writing talent on this board, I can't see that it should be too difficult to do.

Gimme a yell,

Ken

[Lhotch]

here is a start you will need to modify as needed for content and formatting.

PHP Code:

<?php

require_once('includes/init.php');

    //now setup the search query
    $sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pBold, p.pHighlighted, u.state, u.city, u.country, u.username FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.title DESC";
    
    //buld array of listings
    $ads = array();
    $result = $db->query($sSQL);
    while ($rs=$result->fetch()) 
    { 
        $ads[] = $rs;
    }
    
    
    // list returned threads
    if (!empty($ads))
    {
        foreach ($ads AS $listing)
        {
            echo $listing[title];
            echo $listing[description];
            echo "<br />";
            
        }
    }

?>

[PFZ_Ken]

Thanks for the code Larry, what do I do with it, specifically?

Ken

[Lhotch]

stick it in a file in the root of your classifieds and pioint a browser at it.

[PFZ_Ken]

Ok, that works but includes every word in every listing, so I'll need to tweak it for inclusion and formatting. Wish I knew more about CSS....

Thanks Larry,

Ken

[PFZ_Ken]

Ha, coolness....

Inventory Plain Text List

Now, only two things and it will be perfect (in order of importance)

1) The list is in reverse alphabetical order, how can I correct this to alphabetical order?

2) While I did say one major use of this function will be to print out a list, I can see it coming that it will be useful to be able to pull this list up in a browser and then click on the title to go to the listing. How do I make the title clickable?

If necessary I can have two links, one to the plain text link for printing, the other for clickable titles.

Answer these two and I'll dance at your next wedding!

Ken

[Mike-N-Tosh]

1) change the line with the $sSQL at the end from "DESC" to "ASC"

2) That would be much, much more complex. I don't really see the point however as the original intent was so people could "print out" a list. If they're already online, then they can easily use the site as intended including browse, search, etc.

-Mike

[PFZ_Ken]

Originally Posted by Mike-N-Tosh

1) change the line with the $sSQL at the end from "DESC" to "ASC"

2) That would be much, much more complex. I don't really see the point however as the original intent was so people could "print out" a list. If they're already online, then they can easily use the site as intended including browse, search, etc.

-Mike

Thanks Mike, show's you what I know, I read "DESC" as "Description". Anyway, it's done. Point taken about "2)". I guess I've heard "that's fine but...." after showing the powers that be the lastest change too many times...now I'm starting to anticipate the "buts".

I'll leave it as is and the first "but" gets my patented "Pre-Postal" look....

Thanks guys, Larry and Mike. If you're lurking but haven't paid the modest price for 68c and happen to see this thread, this community support is one of the things that makes 68c great. I've paid ALOT more for software, scripts etc. and gotten much, much less in the way of support.

Ken