<?php
// open base
$con = mysql_connect("xxxxxxxxxxx", "xxxxxxxxxxx", "xxxxxxxxxxxxxxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("xxxxxxxxxxx", $con);
// open table
$result = mysql_query("SELECT * FROM leader");
// print table & column headders
echo "<table border='1'>
<tr>
<th>id</th>
<th>Club</th>
<th>Website</th>
<th>Club Badge Url</th>
</tr>";
// get data to fill table
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['club'] . "</td>";
// gets website url and makes it clickable
echo "<td><a class=\"mylink\" href=\"" . $row['website'] . "\">" . $row['website'] . "</a></td>";
//gets pic. url and displays in box 78 x 78
echo "<td>" . $row['url'] . "</td>";
echo "</tr>";
}
echo "</table>";
// close base
mysql_close($con);
?>
I am working on the above code and have 2 problems {so far}
1/ the links end up like " mysite.com/www.outputsite.com " insted of "www.outputsite.com "
2/ trying to get the url to become a pic insted of just text.
thanks in advance.