Links in MySQL results (PHP)
<? $name = "obj"; $query = "SELECT CC_Title as Title, CMS_Tree.CT_Id as Id, CMS_Tree.CT_Name as Name FROM CMS_Tree INNER JOIN CMS_Contents ON (CMS_Tree.CT_ContentId = CMS_Contents.CC_Id) WHERE CMS_Tree.CT_Parent = '1'"; $connection = mysql_connect("localhost", "user", "password"); mysql_select_db("db"); $data = mysql_query($query, $connection); echo activewidgets_grid($name, $data); ?>
So I have 3 columns, but I'd like to add link like edit.php?id=$row[CT_Id] to the first column, i.e. CC_Title, and not to show the column with Id's.