Links in MySQL results (PHP)
How can I add links to MySQL SELECT results? I use slightly changed code from examples:
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.
I've found a post with the same problem (http://www.activewidgets.com/javascript.forum.2816.2/link-mysql-php.html), but I can't understand where to add this code.
<?
$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.
I've found a post with the same problem (http://www.activewidgets.com/javascript.forum.2816.2/link-mysql-php.html), but I can't understand where to add this code.
Celer Nautilus
March 23,