category function

[it53lv]

So i'm writing a little thing and i'm kinda stuck at some simple place
The idea is simple

I have mysql table "categories" with id,name etc
And "data" table with categorie entrie (ore what you call it)

So the problem is this part in code

<a href="torrents.php?by_cat&category=<?= $category ?>"><?= $category ?></a>

as you can see there is dublicate for $category function for link name
but what i wan't is kinda hard for me to explain

so the first $category function puts an category id in front of the link (what it takes from mysql "data" table ) and second one basicly displays the category id as well but what i want is that the second one to show categorie name from "categories" table basing it on it's id from "data" table

So any ideas how to define $category for that i know it's kinda simple but i'm stuck here.

Can any one please help?

[daffy]

which source

[it53lv]

custom made