I have a database that returns information about a customer's jobs that have shipped. It displays correctly, but I would like the carrier name to be a link to the carrier's website so the customer can track it on line. I have the carrier's website listed in the database. how do I make the carrier's name print as a link to their website?
Any help would be greatly appreciated!
$resultb = mysql_query("SELECT * FROM orders WHERE mold='$mold' and shipdate is not null",$db);
if ($myrow = mysql_fetch_array($resultb)) {
echo "<BR/><table cellpadding=\"3\" cellspacing=\"3\" border=\"0\">\n";
echo "<tr bgcolor=\"#B9B8B8\"><td><span class=\"bold\">Mold Number</span></td><td><span
class=\"bold\">Date Shipped</span></td><td><span class=\"bold\">Carrier</span></td><td><span class=\"bold\">Tracking Number,</span></td></tr>\n";
do {
printf("<tr bgcolor=\"#EAE8E8\"><td>%s</td><td>%s</td><td>%s</tr>\n", $myrow["mold"],$myrow["shipdate"], $myrow["carrier"], $myrow["tracking"]);
} while ($myrow = mysql_fetch_array($resultb));
}