Posted by frizzle on 10/05/15 11:31

Hi there,

I've looked in many places for what i need, but i just
can't seem to find it. I keep ending up in ad-managing
systems, or link-trackers ...

I have 1 mySQL table called 'categories':
-> id (INT), category (VARCHAR)

And 1 called 'links':
-> id (INT), cat_id (INT), url (VARCHAR)

I think this part speaks for itself.
What i want is to order the categories alphabetically,
and have them 'populated'. (example below)

Categories without any links in them (yet) shouldn't show
up at all. I Just cannot figure out the query.

Any help out there?

Greetings Frizzle.


********* E X A M P L E **********

category: COOL SITES
- http://www.icecold.com
- http://www.freezing.com
- http://www.frost.com
- http://www.freezing.com

category: HOT SITES
- http://www.fire.com
- http://www.sunbathing.com

(hope that's clear)

[Back to original message]