Re: How to explode an array from a Database?

I tried to use the following (base) code:

----8<------------------------------------------------------------------
[01] $db_link   = db_connect();
[02]  $db_result = db_query($db_link, "SELECT serial,$category FROM categories");
[03]  $cat_array = db_fetch_all($db_result);
[04]
[05]  sort($cat_array, SORT_NUMERIC);
[06]
[07]  foreach($cat_array as $row) {
[08]    extract($row);
[09]    $strg .= "        <a href=\"/?what=category&num=$serial\">$category</a><BR>\n";
[10]  }
[11]
[12]  db_close($db_link);
----8<------------------------------------------------------------------

the problem is in db_query (line 02) with "$category"  where  the  value
can change between e.g.

category
cat_de
cat_fr
cat_ee
cat_ru
...

so, how I can evaluate the name of the value of the  variable  $category
in line 09?

Thanks

-- 
Michelle Konzack        Miila ITSystems @ TDnet
GNU/Linux Developer     00372-54541400

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQIcBAEBCAAGBQJZKt/0AAoJEKWVf9iDRXPiAWYQAIyCswcFaVjzgWzKHW3VolRa
wicUsDnVRzFCRxucxumLl7+dLKh6dh08lmoK6sjwmwJSzMXonWnQ0rkFfJzxC3HQ
31Qe+tFMEZTHBGunlgv1WQNm6f/mrQd+fi+Xekmp3oq/pg6t06QaivSDxgFuWQvU
j0spX1r5o9Z2A4UFf/mCy9mvq8hOzo6A5fJrW03aWPuHSgI7dAKMLwpMkoDZbveP
2SDViKLRgskMgPnWndLaHmQ3blZVMEGvkPNWKd8lKkix5DvxpWCAWOihQY+4nCJz
wq0lO4s5hFKPiiRL7V79AoVJvRol9lrL74hYqr9mjS6EZFGGG/TDNoa843SDTcZo
SorvBx5mQkb+pbuXVD2JLrIVr2t26IpKNxQ35sCOX7dNO5p5UrMid3/1GnpIElf/
dH9AHOoh0CCi5Y1MQom78B2u++AmWkIRpTp4FC4Oub3pzDgponjHmLyY0maAY1mJ
vyAQgtjg8hyLf1l1M22s4iZ4apa3ti+nts7cCIvLxmf8QtzBQ0OKG0ieBiWDklEb
55BQ6UWEajcUBTmD22kOmZDA+slKQvQHlOs0T5x000549YT1WopF7QDY9AqNQAyd
dHpDmEsz3cRUOgUynYjSkGjZCzZl9q6u14OSgarBRzIM/4snMLMEA6W7hkEIAj6/
f57FHUhrd4NekPxco4Tn
=BEp2
-----END PGP SIGNATURE-----