Adding Links to Data from DB

[Andy_Frees]

How do you add the necessary code in order to make data pulled from a MySQL db into a link?

Example:

Inside a table

for ($i=0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "<TR><TD bgcolor=#CCCCCC><H6>".($i+1).". ";
echo "</H6></TD><TD bgcolor=#CCCCCC><H6>";
echo ($row["Event_Name"]);
echo "</H6></TD><TD bgcolor=#CCCCCC><H6>";
echo ($row["Course"]);
}

I have the link in another field called "Directory" in the same db. I want to make it so that when they click on the "Course" feild it opens the link in the "Directory" feild.

Thanks for your help.

[nnichols]

for ($i=0; $i < $num_results; $i++) 
{ 
$row = mysql_fetch_array($result); 
echo '<TR><TD bgcolor=#CCCCCC><H6>' . ($i+1).'. '; 
echo '</H6></TD><TD bgcolor=#CCCCCC><H6>'; 
echo $row['Event_Name']; 
echo '</H6></TD><TD bgcolor=#CCCCCC><H6>'; 
echo '<a href="' . $row['Directory'] . '">' . $row['Course'] . '</a>';
}

That will will print "Course" as a link to the URL in "Directory".

Hope this helps 😉

P.S. Use 'single quotes' instead of "double quotes" unless you want variables within the string to be parsed.

[Andy_Frees]

Very nice 🙂