Search Results to show category

[Sharr76]

When you carry out a search and the search is displayed would it be possible to show the category that the site belongs too?

For example a search for photographers currently show this:

Denise Chastain Photography
Includes portraits, documentary, Silo street shoot and contact detals.

Is it possible to show it like this:

Denise Chastain Photography (Photographers)
Includes portraits, documentary, Silo street shoot and contact detals.

(Photographers) would also be hyperlinked to display the full category when clicked on.

:?:

[/url]

[Ap0s7le]

Taken care of.

Thank you Sharon.

-Casey

[Ap0s7le]

David asked me to post how I did this.

Here goes.

In the /index.php there is a section that looks for the query string in the URL.
That section in the latest version looks like this starting on line 63. In that block you'll find a query like so.

$feat_links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND (URL LIKE $q OR TITLE LIKE $q OR DESCRIPTION LIKE $q) AND FEATURED=1 $expire_where ORDER BY EXPIRY_DATE DESC");

Change that line to.

$feat_links = $db->GetAll("SELECT l.*, c.TITLE cTITLE FROM {$tables['link']['name']} AS l, {$tables['category']['name']} AS c WHERE l.STATUS=2 AND l.CATEGORY_ID = c.ID AND (l.URL LIKE $q OR l.TITLE LIKE $q OR l.DESCRIPTION LIKE $q) AND l.FEATURED=1 $expire_where ORDER BY l.EXPIRY_DATE DESC");

Now just a couple lines below that find.

$links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND (URL LIKE $q OR TITLE LIKE $q OR DESCRIPTION LIKE $q) $feat_where $expire_where ORDER BY {$sort_cols[$sort]} {$sort_ord[$sort]}");

Change it to.

$links = $db->GetAll("SELECT l.*, c.TITLE cTITLE FROM {$tables['link']['name']} AS l, {$tables['category']['name']} AS c WHERE l.STATUS=2 AND l.CATEGORY_ID = c.ID AND (l.URL LIKE $q OR l.TITLE LIKE $q OR l.DESCRIPTION LIKE $q) $feat_where $expire_where ORDER BY {$sort_cols[$sort]} {$sort_ord[$sort]}");

Now you can access that added Category Title in your templates like so

{$link.cTITLE}

For example with Sharon I used this in the link.tpl

{if $link.cTITLE}(http ://{$smarty.const.DOC_ROOT}/index.php?c={$link.CATEGORY_ID}"]{$link.cTITLE}){/if}

Any questions just yell.

Thanks

-Casey

[David]

I'm thinking that to add the category links only to search results we need to go into main.tpl and do something where "q uneq 0"?

[Ap0s7le]

Nah we don't.

It'll work fine the way I have it listed. You can view it active on her site.

Thanks

-Casey

[David]

Cool, I figured it out now:
http://www.businessplexus.com/index.php?search=ballroom

Somebody give this guy a donation for helping.

[ing]

I got this to work, but is there a way to use ENABLE_REWRITE to make it point to the full url of the category or subcategory (site.tld/category/) instead of going to the category_ID (site.tld/index.php?c=xx) ??

Thanks

[Nobody]

Yeah I wonder that to. Additionally, I think it would be nice if the category spec should show up at "latest links" and "popular links" as well.

And what about the "Suggest a category" feature? How is that one working?

[David]

Originally Posted by Nobody

Yeah I wonder that to. Additionally, I think it would be nice if the category spec should show up at "latest links" and "popular links" as well.

And what about the "Suggest a category" feature? How is that one working?

All we have right now is this:
{deleted}

[mdarriba]

Hi!
How I can do to show the all Strocture Category, with this change in the code only see the las category for the link, is posible to show all tree of the categories?

Thank you for your time

[proprod]

Originally Posted by David

Cool, I figured it out now:
http://www.businessplexus.com/index.php?search=ballroom

Somebody give this guy a donation for helping.

David, I noticed there, it has a link with full cat structure, parent, child... how did you accomplish this?

[Alex2006]

Hi All,
How I can do to show category url in search result?

[Boby]

That is an option of phpLD 3.06

[Alex2006]

Unfortunately I am not able to provide payment for phpLD 3.06 from Russia.

[Boby]

None of the following are available in your case?
http://www.phplinkdirectory.com/foru...07&postcount=6

Maybe a wire transfer could be the best method.

[Alex2006]

This {if $link.cTITLE} Category: <a href="/index.php?c={$link.CATEGORY_ID}">{$link.cTITLE}</a>{/if} work well. How I can to use ENABLE_REWRITE to make Url for category as <a href="{$current_path}{$cat.TITLE_URL}.html">{$cat. TITLE}</a>

[Boby]

That is another feature of phpLD 3.06
It builds the entire link path to the category in the cache no matter if URL is rewritten or not.

[Kaz]

I've added the code but my link to the category doesn't seem to be hyperlinked. Any ideas?

[Kaz]

Originally Posted by David

Cool, I figured it out now:
http://www.businessplexus.com/index.php?search=ballroom

Somebody give this guy a donation for helping.

Could you let us know how you got it working with enable rewrite

[solutionsphp]

What is the conditional statement required to have the category also display on the Latest Links and Top Hits pages?