|
|
Posted by frizzle on 11/07/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)
Navigation:
[Reply to this message]
|