I searched for a week to find out how I can turn one column of mysql results into a clickable link. Now I can produce another query to show more information about a product. In the first field there can be no spaces in the content. The Product can have spaces in the description but to make the Product field into a clickable link, no spaces in the first field’s contents. A unique ID would be good. This will add an extension to the id so you can map it to another file to produce another query or what ever you need, description etc,.
echo “<th align=left>” . “<a href=” . $row[‘p_id’] . “.php” . “>” . $row[‘Product’] . “</th>”;