how to bold, email and web links in mysql query results in table

spikenology

have a simple membership database in mysql. Running a query, and displaying results on a page to show active members.

Need some simple assistance - I want to bold the names, and make the email address links (- mailto: etc.), and make links to folks web sites, if present.

Part of code is below - appreciate any guidance...

$result = mysql_query("SELECT * FROM members where dues > '2009-05-01' and nowebsite <> 'x'");
echo "<table border='0'>
<tr>
<th></th>
<th></th> </tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . "______________________" . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['company']. "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['fname']." ".$row['lname']. "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['phone'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['email'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['website'] . "</td>";
echo "<tr>";
echo "<td>" . $row['description'] . "</td>";
echo "</tr>";
}
echo "</table>";

bradgrafelman

First off, hello and welcome to PHPBuilder!

As to your question... which part do you need help with? Do you not know the HTML code to do what you're asking? Once you know the HTML, it's pretty straightforward; all the PHP is doing is outputting HTML code.

spikenology

Thanks for the quick reply, bradgrafelman!

I understand the basics of html language - e.g. want to use <strong> xxxx </strong> to bold the ['company'] value returned from the database.

I also want the ['email'] value to be a click to a mailto link.

Also be able to click a link for the ['website'] value to launch a new page to their website.

I just am not sure where to insert the html code into the table results structure to work right - if this makes sense?

dagon

for the first one:

echo '<td style="font-weight:bold">' . $row['company']. "</td>";

Frederick

echo "<td><a href=\"mailto:".$row['email']."\">" . $row['email'] . "</a></td>";