Hi - Relatvely new to php.
I have a query that pulls a list of production jobs from a MySQL database and displays them in a nicely formatted Overview table by job name giving some basic summary data. It's been well accepted, so I'd like to have each jobname as a hyperlink so that clicking on it opens another window with a printable job report - start/finish times, production problems etc. I've been experimenting with it for a day or so, can't find anything on the web that gives me what I need, can anyone suggest anything? I can get a hard-coded link working but don't know how to get a link to pull more data from a db.
<?php include('connections.php');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
print ("</tr>");
print ("<td width=\"20%\">");
print ("<br>");
print ("</td>");
print ("</tr>");
print ("<tr>");
print ("<td colspan=\"4\" align=\"center\">");
print ("<tr>");
print ("<td BGCOLOR=\"#99CCFF\" width=\"20%\">");
print ("<b>Job Name<b> ");
print ("</td>");
print ("<td BGCOLOR=\"#99CCFF\" width=\"20%\">");
print ("<b>No. Breaks<b> ");
print ("</td>");
print ("<td BGCOLOR=\"#99CCFF\" width=\"60%\">");
print ("<b>Manufacturer<b>");
print ("</td>");
print ("<b></tr>");
while ($row=mysql_fetch_array($overview_qry))
{
print ("<tr>");
print ("<td width=\"20%\">");
print ($row[1]);<------------------ JOB_NAME LINK IN HERE
print ("</td>");
print ("<td width=\"20%\" align=\"center\">");
print ($row[2]);
print ("</td>");
print ("<td width=\"60%\">");
print ($row[3]);
print ("</td>");
print ("</tr>");
}
print ("</table>");
?>
