First of all, I would recommend using http://php.net/manual/en/book.pdo.php PDO. Having something like db_query($db_link, "SELECT serial,$category FROM categories"); is a bad idea if you are running this code in a web page, because of SQL injections. There is a fetch for assoc and then you can find the array key of the associate array. You'll find a lot of resources just googling some of these words. Maybe look into using the preg_split function and finding a regular expression to split on if you have to do that anywhere. More of the code and samples of data would also help with helping you. On Mon, 29 May 2017 at 02:34 Michelle Konzack <linux4michelle@xxxxxxxxx> wrote: > 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 <+372%205454%201400> >
