[RESOLVED] List data by category

[Popovich88]

Hi.
I have a table in a mysql db with the following structure:

table_links:
id | name | url | category

I want that my php page to take the data from the table and to print the links in the page ordered by category.

Suppose that i have a table with:
1 link1 www.link1.com xxx
2 link2 www.link2.com yyy
3 link3 www.link3.com xxx

The php script should print something like this:

Category xxx:
www.link1.com
www.link3.com

Category yyy:
link2 www.link2.com

I want my script to be dynamic so doesn´t matter the number of categories or links in the db it will group them by category (sorting by category alfabethical for example).

Any ideas how can i do this?

[djjjozsi]

set the order on that table by the category field.

In the while cycle watch if the previous category is equal with the actual one,
if its not then add a page break, or open a new div.

this is working, but your database still poor designed. The categories should stored in a related table.

Read more about Database Normalisation (google)

hello, jjozsi.

[Popovich88]

Thanks. I dont khnow how i didnt thought of that before.

I know about Normalisation but for the site i am building i think is useless to normalize that table.