We Need our table to Render a MachID number from MySql database, we need this MachID to fire a Hyperlink similar to: ~\machines\MachQuote.aspx?MachID={0}.

The intend is for the table to display the MachID, but Hyperlink to the actual Machine quote based on the MachID number clicked.

If you need us to add another field to MySql database that reads i.e.: Machines/MachQuote.aspx?Mach=10182 that the MachID refers to we can do that too.

What is the best way to encode this Hyperlink call out in wpDataTable?

We need to (PHP code) or some other method that allow us to make the MachID Field (hyperlink) that executes a simple command to:

$id = $_GET['machid'];
$result = mysqli_query($con,"SELECT (WHATEVER YOU WANT) FROM (YOUR TABLE) WHERE machid = $machid");

The goal here is to have the hyperlink field point to a specific Machid and a specific page on our site.

echo "<td><a href=\"mysqlupdate2.php?MachID=$MachID=\">$MachID=</a></td>"; 

Can I recode the select table query and add this type of call out?