XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. General XOOPS.org forums / 
  3. XOOPS.org Members Lounge 
  4.  / xdirectory
Register
11
builderb
Re: xdirectory

  • 2004/5/11 3:24

  • builderb

  • Not too shy to talk

  • Posts: 137

  • Since: 2003/8/4 2


Ok, I'm a little confused.

Are you talking about the index page where all the categories and sub-categories are displayed?

If so, Do you just want to display the parent categories only?

If I could see your example site I can provide better help.

builderb
12
builderb
Re: xdirectory

  • 2004/5/11 3:38

  • builderb

  • Not too shy to talk

  • Posts: 137

  • Since: 2003/8/4 2


Ok, after re-reading your last comment I think I know what you're trying to do.

It sounds like to want to have only one category with all the sub-categories for that category show up on the index page.

then possibly create more index pages that show only one category and the sub-categories that go with it.

If that's the case then you will need to edit the sql statement to look like this:

$result=$xoopsDB->query("SELECT cid, title, imgurl FROM ".$xoopsDB->prefix("xdir_cat")." WHERE lid = "YOUR_LID" ORDER BY title") or exit("Error");

replace YOUR_LID with the lid of your chevy trucks category.

Hope this is what you wanted.

-Builderb
13
wtravel
Re: xdirectory

Hi builderb,

I think that instead of:
Quote:
$result=$xoopsDB->query("SELECT cid, title, imgurl FROM ".$xoopsDB->prefix("xdir_cat")." WHERE lid = "YOUR_LID" ORDER BY title") or exit("Error");


it should be:

Quote:
$result=$xoopsDB->query("SELECT cid, title, imgurl FROM ".$xoopsDB->prefix("xdir_cat")." WHERE cid = "YOUR_CID" ORDER BY title") or exit("Error");


Kind regards,

Martijn
14
jayjay1
Re: xdirectory

  • 2004/5/11 4:45

  • jayjay1

  • Friend of XOOPS

  • Posts: 12

  • Since: 2004/4/22


awesome

let me play awhile i'll post the results


JJ
15
jayjay1
Re: xdirectory

  • 2004/5/11 4:59

  • jayjay1

  • Friend of XOOPS

  • Posts: 12

  • Since: 2004/4/22


You guys are on a great role

how do i add some thing like a alpha display of categories;



| A | B | C | D | E | F | G | H etc....

to select by alpha characters ???


jj
16
builderb
Re: xdirectory

  • 2004/5/11 5:14

  • builderb

  • Not too shy to talk

  • Posts: 137

  • Since: 2003/8/4 2


You're right! I think I need sleep.

You should limit the SQL by CID not LID.

Thanks wtravel!

Builderb
17
jayjay1
Re: xdirectory

  • 2004/5/11 5:20

  • jayjay1

  • Friend of XOOPS

  • Posts: 12

  • Since: 2004/4/22


Good Night and Thanks for the input...





JJ
18
banned
Re: xdirectory

  • 2004/5/16 17:31

  • banned

  • Not too shy to talk

  • Posts: 159

  • Since: 2004/5/16


mmh, i have some mistake.
xDirectory just saw to me about:
a) Business Name [_MD_SITETITLE]
b) WebSite [_MD_SITEURL]
c) Decription [_MD_DESCRIPTIONC]

How I can fix?
- I'm translating it in Italian, do you want the files, later? -

EDIT: ehm, ehr, sorry. The only mistake is located here ->127.0.0.1 .. ehr
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

407 user(s) are online (324 user(s) are browsing Support Forums)

Members: 0

Guests: 407

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits