Help with links query

  • Resolved hansd

    (@hansd)


    19 years ago

    I would to make a query in my template to show links from a particular category that start with a distinct letter (‘A’).

    Is there someone who tried to do something like that or knows how to to that?

    I guess some custom php coding would be necessary, first to select a category from the table wp_linkcategories, second to select the wanted links from the table wp_links?

Viewing 2 replies - 1 through 2 (of 2 total)
  • di0fref

    (@di0fref)

    Try this:
    $catsql = “SELECT link_name, link_url FROM links LEFT JOIN linkcategories ON linkcategories.cat_id=links.link_category WHERE linkcategories.cat_name LIKE ‘B%’ ORDER BY link_name ASC”;

    Thread Starter hansd

    (@hansd)

    Thanks, this helped a lot!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Help with links query’ is closed to new replies.

Tags