Databases and Urls

Ledomier

My boss wants me to make a page designed for selling a list of urls he has in a database. He wants the url listed with a description and then a page where someone can make an offer on said url. My problem as of now is that i can get the urls and descriptions to be listed however the urls are not hyperlinks. I cant seem to figure out how to turn them into hyperlinks. Here is the code i am currently using without my failed attempts of making hyperlinks added in.

<?php
$con = mysql_connect("host","user","pword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Information");

echo "<table border='1'>
<tr>
<th>Url</th>
<th>Description</th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row["url"] . " " . "</td>";
echo "<td>" . $row['desc'] . "</td>";
echo "<br />";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>

Piranha

This question is about html. You use <a href="link">text</a> to make it a hyperlink. In your case something like below:

echo "<td><a href='. $row["url"] . "'>" . $row["url"] . "</a></td>";

Ledomier

Tried it, didnt work.

Piranha

I managed to get an error in the code without realizing it. But since you managed to get the url to echo I am sure that you can spot the error and solve it. It will be a good opportunity to debug code.

Anyway I hope that you don't use code you get straight away, that you check it before using it. Otherwise you risk getting some malicious code.

Ledomier

I figured it out. Thanks for the help.

bradgrafelman

Don't forget to mark this thread resolved (and give a quick explanation of what your resolution was, in case someone else comes along with the same problem and sees this thread).

Also, when posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.