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

Attachment: [application/pgp-signature] Digital signature signature.asc